ID 1072

PROBLEM: IIS is prompting for username and password when accessing reports or graphs

Description
Your web browser will prompt for a username and password when attempting to access a page in the Web Tracks /Reports folder.

This behavior can happen if the following is true:

1. You have changed the root of your site in IIS from http://YourServerName/WebTracks to http://YourServerName

2. SQL Server 2008 is installed with reporting Services

When the above is true SQL Server Reporting Services intercepts requests to the http://SiteRoot/Reports folder.




Resolution
To solve this problem you must change the default URL that SQL Reporting Services uses. To do this perform the following steps:

1. Open SQL Reporting Service Configuration Manager

2. In the left hand menu select 'Report Manager URL'

3. Change the URL folder from 'Reports' to 'SqlReports'

4. Save the configuration changes


Date: Monday, March 17, 2014

Knowledge Base Search