SSRS 2008 R2 Subscription Email Error (only with Attachments)
I am having the same issue as in the following post http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/6a4ee2d8-23ce-4b68-a14e-fe7024cb58ea. I have SSRS 2008 R2 set up on a Windows Server 2008 SP2 server. Everything works fine, with the exception of subscriptions with an attachment. If the subscription is just a link, it works fine. In reviewing the log files, I get the following error info: library!WindowsService_8!e6c!04/25/2011-13:32:06:: 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. ; library!WindowsService_8!e6c!04/25/2011-13:32:06:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. emailextension!WindowsService_8!e6c!04/25/2011-13:32:06:: e ERROR: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. notification!WindowsService_8!e6c!04/25/2011-13:32:06:: e ERROR: Error occured processing subscription bf7ba260-6f39-4915-834c-70ca36a616ef: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent. When I review the KB article mentioned (link below), the top specifically says "Note This problem does not occur in Windows Server 2008" http://support.microsoft.com/kb/842423 Since I have it installed on a Windows Server 2008 box, and am experiencing this issue, is there something different that people know of for that version of Windows Server? - Glenda
April 26th, 2011 10:38am

Hi Glenda, Thank you for the post. Basically, the error code 5 means "Access is Denied". You can verify this by running "net helpmsg 5" under a CMD.exe window. Meanwhile, the error message is also quite clear that the account that is used to start the Reporting Service does not have sufficient right to check domain user SIDs. Generally, the issue is related to AD infrastructure rather than SSRS itself. The cause of the issue could be that, AuthzInitializeContextFromSid function call will be invoked before Reporting service sending out an subscription Email with attachment to the users who subscribed it. However, for link subscription, AuthzInitializeContextFromSid would not be called. To work on this issue, please try follows, 1. Verify if the SSRS has been joined to the same domain with the users. 2. If the user account and the SSRS computer account belongs to different domains, please setup two way trust between them. 3. Use a domain account which belongs to the users' domain to start the SSRS service. 4. Try to re-subscribe the reports by using the SSRS's local admin account. If the issue still occurs, you can post the thread to AD forum, http://social.technet.microsoft.com/Forums/en-us/winserverDS/threads. Hope you can get the issue resolved soon with helps from appropriate team. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 9:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics