rsWindowsIntegratedSecurityDisabled error when running Reporting Services report in SharePoint integrated mode
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!
