Sql – Login dialog appear in IE7 when browsing SQL Reporting Services

64-bitiisreporting-servicessql server

Setup is SQL2005 SP2 with Reporting Services installed local on Win2003 64bit.
When users browse report manager on http://server/reports they get login dialog for every request, but only if they use IE7. In FireFox all works.

The site is in "local intranet" zone on IE.

It seems like it is a NTLM, I've tested reinstall, change permission on service account, change permission on SRS directory, no works.

Best Answer

Solution!

Change NTAuthenticationProviders on IIS with adsutil.vbs script to "NTLM,Negotiate" (script found in \inetpub\adminscripts)

run

cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "NTLM,Negotiate"

(w3svc/1/ is the default website, change 1 to the right website nr)

to verify settings run

cscript adsutil.vbs get w3svc/1/root/NTAuthenticationProviders

Related Solutions

Sql – Reporting Services Report Manager Generating Report Message

Run it on the Report Server and do a view source when the "Generating Report" message is displayed.

Do the same on the other server when the "Generating Report" message should be displayed.

I suspect that some files/images might be missing.

R – getting an error with Reporting Services Add-in for Sharepoint products

Maybe You receive an "HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials" error message when you try to access a Web site that is part of an IIS 6.0 application pool

When you try to access a Microsoft Internet Information Services (IIS) 6.0 Web site that is configured to use Integrated Windows authentication only, you are prompted for your user credentials. When you try to log on, you receive the logon prompt again. After you try to log on three times, you receive the following error message:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.

...

Start a command prompt.

Locate and then change to the directory that contains the Adsutil.vbs file. By default, this directory is C:\Inetpub\Adminscripts.

Type the following command, and then press ENTER:

cscript adsutil.vbs set w3svc/NTAuthenticationProviders "NTLM"

To verify that the NtAuthenticationProviders metabase property is set to NTLM, type the following command, and then press ENTER:

cscript adsutil.vbs get w3svc/NTAuthenticationProviders

  The following text should be returned:

NTAuthenticationProviders       : (STRING) "NTLM"

Best Answer

Related Solutions

Sql – Reporting Services Report Manager Generating Report Message

R – getting an error with Reporting Services Add-in for Sharepoint products

Related Topic