Wednesday, August 24, 2011

Setting up subscriptions in SSRS 2008

When setting up subscriptions to some reports in Reporting Service 2008, you might need to log in as the service account that runs your reporting service and open the report manager url in the browser and do the set up. The reason behind is if you use different account from the SSRS service account, the AuthzInitializeContextFromSid API function call may fail. The error message is similar to the following:

The report server has encountered a configuration error. , AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.

The Reporting Services program calls the AuthzInitializeContextFromSid API function to verify whether the user account that was used to create the subscription still has the correct permissions to view the report. This verification is not required when the e-mail contains only a link, a URL, to the report because Reporting Services performs user permissions verification when the user tries to access the report by using the URL.

The simple solution is to log in as the service account the do the setup under this account.

No comments: