Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
You receive an error message when you use SQL Server 2008 Reporting Services: "HTTP 401.1 - Unauthorized: Logon Failed"
Article ID: 956158 - View products that this article applies to.
Consider the following scenario that occurs when you use Microsoft SQL Server 2008 Reporting Services:
Note 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:
HTTP 401.1 - Unauthorized: Logon Failed
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:
The name 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:
(http://support.microsoft.com/kb/896861/ )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
Article ID: 956158 - Last Review: March 19, 2009 - Revision: 2.1