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?

more ▼

asked Jun 01, 2011 at 07:34 AM in Default

avatar image

31 3 3 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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
How to: Configure a Service Account for Reporting Services
How to: Register a Service Principal Name (SPN) for a Report Server

more ▼

answered Jun 01, 2011 at 08:12 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 01, 2011 at 07:34 AM

Seen: 1787 times

Last Updated: Jun 01, 2011 at 07:34 AM

Copyright 2017 Redgate Software. Privacy Policy