Sunday, February 20, 2005 2:03 PM bart

SQL XML on IIS 6

Maybe some of you have been struggling with this... When creating a SQL XML vdir on IIS 6 servers, the tools create a wildcard mapping for the vdir to the sqlisapi.dll. However, when browsing to the vdir to perform a query or to call a template, you receive a 404 message. IIS 6.0 always sends a 404 message if an ISAPI is not allowed to execute. For example, if ASP.NET is installed on the system but not enabled, navigating to an .aspx file on the server (even if it exists) will result in a 404 error message (to mislead hackers too). The same holds for SQL XML. To get it up and running, go to the Web Service Extensions node in the inetmgr tool and add a new extension for SQL XML, mapping to the ISAPI file (in my case this is C:\Program Files\Common Files\system\ole db\sqlisapi.dll). Finally, allow the extension and everything should be okay.

Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Filed under:

Comments

# re: SQL XML on IIS 6

Monday, May 09, 2005 5:31 AM by bart

That was it. Great tip. MS didn't include this in their how to. Thanks

# re: SQL XML on IIS 6

Sunday, May 22, 2005 9:50 PM by bart

great tip man! i been close to bangin me head against the wall with this thing
they dont ever mention that thing anywhere

# re: SQL XML on IIS 6

Monday, September 26, 2005 11:08 PM by bart

Thank you!