Thursday, January 27, 2011

SSRS E-Mail Subscription Setup

One of the best parts of a report repository like SQL Server Reporting Services or Business Objects Enterprise is the ability of the system to push out reports to users. One of the most popular ways is a subscription through the e-mail server. However, undoubtedly convenient for the users, the administrator can sometimes have a difficult time getting it setup. This was a case during a recent setup of a SSRS environment where the task was to setup e-mail.
On the SSRS server, I was using a service account in the local domain and had setup the SMTP server based off how I had Business Objects setup. By the way, what you put in for the sender address does not seem to matter and can be what your users want to see.

After everything was setup and I tried a test subscription, I got an error message in the status: “Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.”

Without any detail in the above message, I went to the log file located on the RS server. You can find it at: C:\Program Files\Microsoft SQL Server\(RS Version).(Instance)\Reporting Services\LogFiles.

The meaningful message I got out of this was:
library!WindowsService_8!7c0!01/21/2011-15:00:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

The common solution to this issue seems to be adding the service account to Windows Authorization Access Group (