Contains notes and lessons in working technology, especially .NET, Azure, DevOps, Agile, and Team Foundation Server.

Monday, October 11, 2010

TFS and Reporting Services Access Issue

After installing and configuring Team Foundation Server 2010 with Reporting Services, I was unable to access the Reporting Services instance from any other box besides the server itself, regardless of the account used (even the setup account was denied).  I would hit the host/reports site and would be prompted for a username and password and even when putting valid credentials in, the site would still deny me. The solution ended up being to remove the Windows Negotiate authentication option from the RSReportServer.config file.  This file is located at %Program Files%\Microsoft SQL Server\INSTANCENAME\Reporting Services\ReportServer.  Remove the RSWindowsNegotiate node under Authentication/AuthenticationTypes.

image

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.