SSRS Error: Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.

SSRS Error: Getting the following error when trying to setup SSRS subscription… Failure sending mail: The specified string is not in the form required for an e-mail address. Mail will not be resent. Issue: If you are using an SMTP server or forwarder that uses e-mail accounts that are different from the domain user account,... » read more

Setup Email Subscription for SSRS

To setup email for SSRS subscription, go to Report Server Configuration Manager. Go to the E-mail Settings and fill in the SMTP Settings fields. Sender Address: me@mydomain.com Current SMTP Delivery Method: Use SMTP server SMTP Server: smtp.mydomain.com Authentication: No authentication Note: Make sure to restart the SSRS service after making modifications to these fields.

SSRS Report Execution Log

Sources: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver16

Install Microsoft Report Builder

Microsoft Report Builder is a stand-alone app for authoring paginated reports, installed on your computer by you or an administrator. An administrator typically installs and configures Reporting Services, grants permission to download Report Builder from the web portal, and manages folders and permissions to reports and shared datasets saved to the report server. For more... » read more

Enable SSRS Email Subscription

Go to Report Server Configuration Manager and set the E-mail Settings. Restart SSRS services. On SSRS, you will now see an “Email” subscription option when you create new SSRS subscription.

Report Viewer Download

Microsoft Report Viewer 2015 Runtime https://www.microsoft.com/en-us/download/details.aspx?id=45496 Install Errors Microsoft System CLR Types for SQL Server 2014 is missing. Download Microsoft SQLSysCLRTypes from Official Microsoft Download Center

SSRS and Large Datasets

Note: Do not attempt to select more than 1 million rows into the resulting Excel Spreadsheet or the data selection process may run out of memory. Large reports present certain processing challenges and require certain configurations if they are to run properly. Large reports should not be run on demand unless they are configured to... » read more

SSRS General Error

Error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors Fix: To determine the specific cause for this message, review the report server log files,... » read more