question

mongoose avatar image
mongoose asked

Reporting Services 2008R2 - Subscriptions Creation - Authentication And Authorization Fail

The application has operating system Windows 2003 Server and SQL Server Reporting Services 2008 R2. The application uses custom dll to do the authentication and authorization in Reporting Services. There is a SQL job that creates standard subscriptions. This job run under the user Local System. When the job tries to create new standard subscription, the following error occurred: "The request failed with HTTP status 401: Unauthorized." This error is accepted before the authentication and authorization in custom dll (I attached to Reporting Services process and put breakpoint in the authentication function). This problem does not happen with SQL Server Reporting Services 2005 (with all operating systems) and in SQL Server 2008 R2 with Windows 2008. Somebody has any idea how to solve it?
reportingsubscriptionsauthenticationservices
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
If your SSRS2008R2 service is running under AD account, then you probably do not have registered SPN for it. Check this on MSDN: [How to: Configure Windows Authentication in Reporting Services][1] [How to: Configure a Service Account for Reporting Services][2] [How to: Register a Service Principal Name (SPN) for a Report Server][3] [1]: http://msdn.microsoft.com/en-us/library/cc281253.aspx [2]: http://msdn.microsoft.com/en-us/library/bb522727.aspx [3]: http://msdn.microsoft.com/en-us/library/cc281382.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.