IIS Virtual Directory Management for SQL Server

[mendhak]

Have any of you ever used this?

I've been using it for quite some time now, but have always noticed that it will be configured fine and work fine on some servers, but not on others. Earlier, I'd ignore the problem by moving to some other machine and mapping an IIS virtual directory to the remote server.

But now I have a single machine with SQL Server on it as well as IIS, and I need to create a SQL Server Virtual Directory on this machine.

I've seemingly done everything right, even followed the example setup for NWIND in BooksOnLine, but I keep getting a 404, even when I try something simple like this:

http://localhost/nwind?sql=select%20@@version

I'd like to know if any of you have run into such problems before and what you did to fix it.

[mendhak]

In the fine tradition of my postings, as always, I have found the solution within minutes of the post itself.

I had not configured a SQLXML Web Service extension in the IIS manager, which is why nothing was running. After I configured it, it started 'running', but now I get this error:

HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings

I'm not sure what that means. ANyone?

[mendhak]

^^ __ I get the above error for all SQL Queries I run. Nothing to do with the statement obviously.