Password prompt with R2 on a separate machine
Hello,
I am able to access report manager and service URLs locally on a machine running SQL 2008 R2, but when I try openning either of those URLs from another machine under where I am logged under the same user name, I am getting endless password prompts and unable
to log in.
The IE machine is 2003 R2, the server is 2008 R2.
What is wrong here?
//Misha
October 20th, 2010 11:59am
Hi MishkaMishka,
Try to use Integrated Windows Authentication in IIS or refer to the following blog post for further details.
http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx
Thanks
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 12:30pm
If it is not using Windows Auth then how does it authenticate locally?
October 20th, 2010 12:32pm
Hi MishkaMishka,
In SQL Server Reporting Services(SSRS), for a login dialog prompting issue, there are two typical causes:
1. The SSRS is configured to use Kerberos authentication, however, the Service Principal Name(SPN) is not configured correctly.
2. The credential is not passed automatically from the client to the report server.
For the first possible cause, we can force the SSRS to user NTLM authentication follow the blog muhammadsalmanx posted.
For the second cause, please try:
Open the Internet Explorer(IE) Click the menu "Tools" > "Internet Options" Go to "Security" tab. Select "Intranet sites" zone. Click "Sites", and add the Report Server site to the zone. Click "Custom Level", and check the item "Auto logon with current username and password"
Click "OK" to apply.
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 12:38pm