Bagikan melalui

rsWindowsIntegratedSecurityDisabled error when running Reporting Services report in SharePoint integrated mode

  • Artikel

I published a report to SPS, using a custom data source which simply pointed to the database in question and used Integrated Security. When I ran the report, the following error was thrown:

 

An error has occurred during report processing (rsProcessingAborted)

This data source is configured to use Windows integrated security. Windows integrated security is disabled for this report server. (rsWindowsIntegratedSecurityDisabled )

 

"Huh?", I thought. Sure, I can disable SQL Authentication in the DB Engine, but I had no idea I could turn off Windows Integrated security!

 

Well, when setting up your SSRS/MOSS integration settings, you certainly can. I remembered that the fine manual provided by Heidi and friends mentioned that if you set Authentication Mode to "Trusted Account" in the Configure Reporting Services Integration screen of SPS Central Admin, you can't use Windows auth.

 

So I checked, and sure enough, I had fat-fingered this setting. When I switched it back to "Windows Authentication", everything worked nicely.

 

To check for yourself, follow these steps:

 

1. Launch SharePoint 3.0 Central Administration.

2. Click Application Management in the left-hand navigation bar.

3. Under the Reporting Services item list, click Manage Integration Settings.

4. Check out Authentication Mode!

Comments

  • Anonymous
    February 13, 2007
    I'm having different issues on the same page. I keep getting a "Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized." error on the reporting services server defaults page.  I'm running a seperate report server from our MOSS servers and I cannot get past this error.  Have you read or heard about it anywhere?  I believe the delegation is set up correctly.

  • Anonymous
    February 22, 2007
    I am having the same problem as Jason.  Anyone have any ideas?  The Sharepoint application pools and services and the Reporting Services application pools and services are all running under a domain account that has appropriate priveleges.

  • Anonymous
    February 28, 2007
    Jason - did you created the SPN for the accounts that are running the webservices and service on the SSRS config?

  • Anonymous
    April 10, 2007
    The comment has been removed

  • Anonymous
    April 18, 2007
    Sorry, I'm not an SPS guru...FBA?

  • Anonymous
    April 23, 2007
    Forms Based Authentication (FBA) :o)

  • Anonymous
    July 13, 2007
    I'm encouraged that it sounds like some of you have been able to make this integration work.  Like Jason, I'm stalled at step 3 Set server defaults.  Error 401 when connecting to ReportServer.  I can't think of what else to verify:SPN created for the MOSS and SQL service accountsWindows Integrated authentication turned onAnonymous turned off.It's a nice idea, but the setup is so painful that I'd have given up a long time ago, but there are some sharepoint devotees who won't take no for an answer.

  • Anonymous
    January 31, 2010
    Hello, any solutions for this problem?

  • Anonymous
    February 10, 2010
    any soultion for this problem, when i change it back windows authentication , set server default doesnt work

  • Anonymous
    November 30, 2011
    December 2011, and still the same problem ... Did anyone solved that problem?