"HTTP Error 401.3 Access Denied" Error Message When You View a SQL Server 2000 Service Pack 2 Database on Windows Server 2003 (816674)



The information in this article applies to:

  • Microsoft Windows Server 2003, Web Edition
  • Microsoft Windows Server 2003, Standard Edition
  • Microsoft Windows Server 2003, Enterprise Edition
  • Microsoft Windows Server 2003, Datacenter Edition
  • Microsoft SQL Server 2000 (all editions) SP2
  • Microsoft Windows Small Business Server 2003, Premium Edition
  • Microsoft Windows Small Business Server 2003, Standard Edition

SYMPTOMS

When you view a SQL Server 2000 Service Pack 2 database in your browser using HTTP on Windows Server 2003, you may receive the following error message:
Error 401.3 Access Denied

You are not authorized to view this page.

CAUSE

This behavior occurs because the SQLXML ISAPI extension DLL is not enabled in Internet Information Services (IIS) Server on Windows Server 2003. You must enable this DLL to use HTTP to view a SQL Server 2000 SP2 database in your browser in Windows Server 2003.

RESOLUTION

To resolve this problem, enable the SQLXML ISAPI extension DLL in IIS Server on Windows Server 2003, and set the WWW service to IIS 5.0 isolation mode instead of IIS 6.0 mode. To do this, follow these steps:
  1. Allow the SQLXML ISAPI extension DLL:
    1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
    2. Click "server name" (local computer), right-click Web Service Extension and then click Add a new Web service extension.
    3. In the Extension name box, Type SQLxml, click Add, and then locate \Program Files\Common Files\System\Ole DB\sqlisapi.dll in the Required files box.
    4. Click to select the Set extension status to Allowed check box.
    5. Click OK.
  2. Stop, and then restart the IIS Admin service:
    1. Click Start, point to Administrative Tools, and then click Services.
    2. Right-click IIS Admin Service, and then click Stop.
    3. Make sure the service is stopped, right-click IIS Admin Service, and then click Start.
  3. Set Web service in IIS 5.0 to isolation mode:
    1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
    2. Right-click Web Sites, and then click Properties.
    3. Click the Services tab.
    4. Click to select the Run WWW service in IIS 5.0 isolation mode check box, and then click OK.

Modification Type:MajorLast Reviewed:12/18/2003
Keywords:kbbug KB816674 kbAudITPRO