/Reports/ Folder Prompts for Login

Plesk Servers > SQL > MSSQL
 
/Reports/ Folder Prompts for Login

Issue
When you go to a URL in your website that has /REPORTS/ in it, a popup box displays asking you to log in.

Cause 

This is caused by using MS SQL Server 2008 Reporting Services.  In previous version of Reporting Services, MS SQL Server created a virtual directory that was used for reporting. However, SQL 2008 talks directly to HTTP.SYS and bypasses IIS directly for registering the /REPORTS/ virtual directory.

Resolution
To resolve this issue, you must disable Reporting Services for MS SQL 2008 using the following instructions.  If your site is on a shared server this must be done by a member of the support team. Open a ticket through your control panel explaining the situation.
  1. Log into your server via Remote Desktop
  2. Click on Start > Administrative Tools > Services
  3. Select SQL Server Reporting Services and click STOP on the left hand side.
  4. Right click on SQL Server Reporting Services and click Properties.
  5. Set Startup Type to Disabled and click OK
 Reporting services will now be disabled and the URL should work correctly.

Add Feedback