When setting up a Team Foundation Server 2008 environment, I ran into some problems with Reporting Services.
The environment consists of:
- Windows 2008 server
- SQL Server 2008
- Team Foundation Server 2008
This is a supported configuration for TFS, and with a lot of manual configuration the environment was finally functioning fine. Except the Reporting part…
When accessing a report, any non-admin user got challenged with an authentication prompt. After three attempts they received a blank screen without a report.
On the web there were several articles about this problem, but none were able to provide the solution. After some testing and digging around in the server, the authentication type seemed to be the problem.
One of the articles I found was about disabling Kerberos on the server (IIS7), and it described my exact problem. But unfortunately it didn't help. The problem was still there. It seemed not to work.
After some more digging I found the answer in the SQL books online of TechNet. One line in the chapter was:
In previous versions of Reporting Services, all authentication support was provided by IIS. In this release, IIS is no longer used. Reporting Services handles all authentication requests internally.
Ah… That’s why turning the Kerberos setting off in IIS didn’t help. After this the solution was straightforward. I removed the RSWindowsNegotiate option from the RSeportServer.config file and my authentication problem was solved.
The link to the full chapters on TechNet SQL books online: http://technet.microsoft.com/en-us/library/cc281310.aspx