Asking for User Name and Password when connecting to Report Manager

Problem:

 When I openned http://localhost/reports, I got the username/pw dialog. This post basically says that if you can connect to SSRS via SSMS but cannot connect to report manager, you could try to remove RSWindowsNegotiate and ensure RSWindowsNTLM is specified in the file rsreportserver.config. But it did not help.

 Solution:

 Run the IE as an admin.

Some Issues on Installing and Connecting to SSRS 2005 on Windows XP

I have SQL Server 2005 SP3 (9.0.4053) installed on XP SP3 but no SSRS. So I decide to install SSRS.

Step 1. Install IIS - OK
Step 2. Install SSRS - OK
Step 3. Configure Reporting Services
Problem on Database Setup
Solution: 
Need to run SP3 again to update the newly installed SSRS for the reportserver database
Step 4. Connecting to SSRS
Problem:
No connection could be made because the target machine actively refused it 127.0.0.1:80
 Troubleshooting
  1. Checked: remote connection enabled, TCP/IP enabled, SQL Browsing running, restarted SQL Server service, but still the same
  2. Back to IIS Installation (from Add/Remove Windows Components in XP), Under World Wide Web, selected Remote Desktop Web Connections. Now the error message is:


The new error message helps! The message basically indicates the problem is related to the mapping between IIS and ASP.NET (because the .NET framework was installed first, IIS was installed later). This issue has been addressed by MS KB 306005.
Solution
Run the following DOS command: 
"C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe" -i



Subscribe to: Posts ( Atom )