DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 956158 - Last Review: March 19, 2009 - Revision: 2.1

SYMPTOMS

Consider the following scenario that occurs when you use Microsoft SQL Server 2008 Reporting Services:
  • You try to access Report Manager or Report Server by using a URL that resembles one of the following URLs:
    http://name/reports
    https://name/reports
    Note The name placeholder is not the name of the computer on which Report Server and Report Manager are deployed. However, the DNS Client service, the computer's hosts header files, or the computer's Lmhosts files that are located in the C:\WINDOWS\system32\drivers\etc folder are configured to send requests to name back to the report server computer.
  • You try to access Report Server directly by using one of the following URLs. When you do this, you experience no problems. Additionally, you can browse the Report Server namespace and view all reports by using the following URLs:
    http://name/reportserver
    https://name/reportserver
  • The ReportServerUrl element is specified in the Rsreportserver.config file and is set to resemble one of the following URLs:
    http://name/reportserver
    https://name/reportserver
  • You try to access Report Manager by using one of the following URLs:
    http://name/reports
    https://name/reports
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
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:
  • 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.

CAUSE

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.

RESOLUTION

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:
  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
  3. Right-click MSV1_0, point to New, and then click Multi-String Value.
  4. Type BackConnectionHostNames, and then press ENTER.
  5. Right-click BackConnectionHostNames, and then click Modify.
  6. 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.
  7. Exit Registry Editor, and then restart the computer.

MORE INFORMATION

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.

REFERENCES

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
896861  (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

APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
Keywords: 
sql2008relnotereportingservices sql2008relnote kbtshoot kberrmsg kbexpertiseinter kbprb KB956158
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support