I've two servers on which there is the SQL 2000 Server and the IIS 6.0.
I installed the SQL Server Client Tools on web server.
And created the nwind as told in booksonline.
I declared the SQLXML extention and allowed it using IIS 6.
But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.
The web server shows the following error.
ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings
Thanks for any suggestions.Ok,
Do not use Client Tools any more on web server.
Instead, yuo can use SQLXML 3.0.
This solved my problem.|||Cool. Glad it's solved. The good news is that Yukon integrates all these features, so there won't be this kind of confusion. That is, if you can wait a year or so for Yukon!
Don
