Showing results for 
Search instead for 
Did you mean: 

Email settings in Sql Server Reporting Services


Email settings in Sql Server Reporting Services



Re: Email settings in Sql Server Reporting Services

How to troubleshoot Advanced Reporting Subscriptions in SQL Server Reporting Services.  E-mail Failures.


When E-Mail subscriptions are set up in Advanced Reporting, they can stop sending if the email server used has been changed or if server not reachable.  When you check your subscriptions, you will see failure statuses.



In some cases, the problem can be caused by the currently configured email server may have been decommisioned the new server not configured.  To check and change if needed, you would do that in SQL Server Reporting Services (SSRS) Configuration Manager.


To Check:

1 Open SQL Server Reporting Services Configuration Manager



2 Connect to the server when prompted



3 Click the E-Mail Settings link on right side of window.




4 Make any change to the SMTP server that was made by entering new or correct SMTP server address.




5 Click apply to save change.  You shouldn't have to make any changes to individual subscriptions. 


Once you save changes, the next time the subscriptions are scheduled, they should run normally and you subscription status should show successful run statuses.






Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar
Top Liked Members