Consider the following scenario that occurs when you use Microsoft SQL Server 2008 Reporting Services:
In this scenario, you receive what resembles the Report Manager user interface. However, where you expect to see a list of reports, you receive the following error message:
HTTP 401.1 - Unauthorized: Logon Failed
If you use SharePoint Integrated mode, you receive the error message on the SharePoint Web pages. The symptoms in this scenario are most likely to occur when one of the following conditions is true:
- Reporting Services is deployed in a scale-out deployment.
- Reporting Services is accessed by using a user-friendly name that does not match the computer name.
This problem occurs because Windows includes a loopback check security feature that helps prevent reflection attacks on your computer. Therefore, authentication fails if the FQDN or the custom host header that you use does not match the local computer name.
To resolve this problem, specify the host name. To specify the host names that are mapped to the loopback address and that can connect to Web sites on your computer, follow these steps:
- Click Start, click Run, type regedit, and then click OK.
- In Registry Editor, locate and then click the following registry key:
- Right-click MSV1_0, point to New, and then click Multi-String Value.
- Type BackConnectionHostNames, and then press ENTER.
- Right-click BackConnectionHostNames, and then click Modify.
- In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.
- Exit Registry Editor, and then restart the computer.
placeholder is considered a host header. It is an alternative name for the computer on which Reporting Services is installed. You must add the NetBIOS and the Fully Qualified Domain Name (FQDN) for name
to the BackConnectionHostNames list that is stored in the Windows registry.
For example, if name
is a Windows computer name, such as contoso
, the name can likely also be referenced in FQDN form as contoso.domain.com
. You must add both representations to the list in BackConnectionHostNames.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or IIS 6