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
sql-server-2008
|reporting-services
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