SQL Server Reporting authentication not working

Posted by Keith on Server Fault See other posts from Server Fault or by Keith
Published on 2012-09-18T20:25:02Z Indexed on 2012/09/18 21:40 UTC
Read the original article Hit count: 216

I'm not exactly sure what went wrong but our SQL Server Reporting Services authentication is no longer working correctly. When I try to load the site, it asks for a username and password, and mine doesn't work.

I checked the service and it is using the NT AUTHORITY\NetworkService to logon. Since it is using NetworkService to logon, I read on Microsoft's site that I need to use these settings in the RSReportServer.config file:

<AuthenticationTypes>
    <RSWindowsNegotiate />
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>

Which is what I have set. It still asks for the password. When I set the Authentication to RSWindowsNTLM, it does login but everytime I click on a link, it asks for a password (the password doesn't seem to prevent anything from loading).

Anyone know what is going on here? I'm not an expert to SQL Server so I may be missing something.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about reporting-services