cancel
Showing results for 
Search instead for 
Did you mean: 

Email settings in Sql Server Reporting Services

Email settings in Sql Server Reporting Services

 

1 REPLY 1

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.

failure.PNG

 

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

 

open-SSRS1.PNG

2 Connect to the server when prompted

SSRS-connect.PNG

 

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

email1.PNG

 

 

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

 

email3.png

 

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.

 

success.PNG

 

 

 

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