Microsoft KB Archive/816674

= &quot;HTTP Error 401.3 Access Denied&quot; Error Message When You View a SQL Server 2000 Service Pack 2 Database on Windows Server 2003 =

Article ID: 816674

Article Last Modified on 12/3/2007

-

APPLIES TO


 * Microsoft Windows Server 2003, Web Edition
 * Microsoft Windows Server 2003, Standard Edition (32-bit x86)
 * Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
 * Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
 * Microsoft SQL Server 2000 Service Pack 2
 * 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:  Allow the SQLXML ISAPI extension DLL:  Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager. Click &quot; &quot; (local computer), right-click Web Service Extension and then click Add a new Web service extension. In the Extension name box, Type SQLxml, click Add, and then locate  in the Required files box. Click to select the Set extension status to Allowed check box. Click OK.</li></ol> </li> Stop, and then restart the IIS Admin service: <ol style="list-style-type: lower-alpha;"> Click Start, point to Administrative Tools, and then click Services.</li> Right-click IIS Admin Service, and then click Stop.</li> Make sure the service is stopped, right-click IIS Admin Service, and then click Start.</li></ol> </li> Set Web service in IIS 5.0 to isolation mode: <ol style="list-style-type: lower-alpha;"> Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.</li> Right-click Web Sites, and then click Properties.</li> Click the Services tab.</li> Click to select the Run WWW service in IIS 5.0 isolation mode check box, and then click OK.</li></ol> </li></ol>

Additional query words: sql xml sqlxml isapi error 401.3

Keywords: kbbug KB816674

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.