Article ID: 810784
Article Last Modified on 3/27/2007
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 2000 Windows CE Edition
- Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
- Microsoft Windows Server 2003, Enterprise x64 Edition
SYMPTOMS
When you access SQL Server 2000 by using HTTP, you receive the following error message:
CAUSE
Windows Server 2003 modifies the implementation of the security model for accessing Internet Server Application Programming Interface (ISAPI) modules. To retain backward compatibility with applications written for Microsoft Internet Information Server 4.0 and Microsoft Internet Information Services 5.0, you must modify the isolation mode in Microsoft Internet Information Services 6.0 on Windows Server 2003.
RESOLUTION
To use any HTTP based SQLXML functionality, configure the server. To configure the server, follow these steps:
- Open the Internet Information Services Microsoft Management console (IIS MMC).
- Right-click Web Service Extension, and then click to select Add a new Web service extension.
- In the New Web service extension dialog box, type SQLXML in the Extension Name text box.
- Click Add.
- The Add file dialog box appears.
- In the Path to File text box, type the location of the file. The file must be for the correct version of the ISAPI library that is in your Program Files folder. For example:
\Program Files\Common Files\System\Ole DB\Sqlisapi.dll
- Click to select the Set extension status to Allowed check box, and then click OK.
- In IIS MMC, right-click <IIS Server>, point to All Tasks, and then click Save Configuration to Disk.
MORE INFORMATION
To reproduce the behavior, follow these steps:
- Create the virtual directory <nwind>. For more information about how to configure a virtual directory by using the IIS Virtual Directory Management SQL Server utility, visit the following MSDN Web site:
Open Microsoft Internet Explorer and locate:
http://IISServer/nwind?sql=SELECT+*+FROM+Customers+FOR+XML+AUTO&root=root
You receive the error message mentioned in the "Symptoms" section.
By default, all versions of the ISAPI library that access SQL Server are installed in this folder:
\Program Files\Common Files\System\Ole DB\
The name of the library varies depending on whether you are using either the original SQLXML functionality or one of the three SQLXML Web releases. To determine the version of SQLXML that is installed on your server, use the following table:
| Release Version | Library Name |
|---|---|
| MDAC 2.6 (or later) or SQL Server 2000 without SQLXML Release | Sqlisapi.dll |
| XML for SQL Server 2000 Web Release 1 | Sqlisapi.dll |
| SQLXML 2.0 | Sqlis2.dll |
| SQLXML 3.0, SQLXML 3.0 SP1, Web Services Toolkit | Sqlis3.dll |
Keywords: kbprb KB810784
