Error message "HTTP error 404 - File or directory not found" occurs when you access SQL Server 2000 with HTTP

When you access SQL Server 2000 by using HTTP, you receive the following error message:

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.

To use any HTTP based SQLXML functionality, configure the server. To configure the server, follow these steps:

1. Open the Internet Information Services Microsoft Management console (IIS MMC).
2. Right-click Web Service Extension, and then click to select Add a new Web service extension.
3. In the New Web service extension dialog box, type SQLXML in the Extension Name text box.
4. Click Add.
5. The Add file dialog box appears.
6. 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
7. Click to select the Set extension status to Allowed check box, and then click OK.
8. In IIS MMC, right-click <IIS Server>, point to All Tasks, and then click Save Configuration to Disk.

To reproduce the behavior, follow these steps:

1. 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:
   http://msdn2.microsoft.com/en-us/library/aa226546(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa226546(SQL.80).aspx)
2. 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: