Accessing SQL via http

Hello,
Apologies if this is in the wrong newsgroup...
I have followed the tutorial in Books Online that is called "Creating the
nwind Virtual Directory". Everything looks ok but I get an error that
says: -
"HTTP Error 404 - File or directory not found. Internet Information Services
(IIS) when I try to test it using http://<IISServer>/nwind?sql=SELECT * FROM
Employees FOR XML AUTO&root=root
I have looked all over trying to find out what I have done wrong
Is there anything else that needs to be set up?
Thanks in advance
Brian.
Could you please disable "Show friendly HTTP error messages" option in
Advanced tab of IE Options? This should give you more precise error
messages.
In the mean time, please ensure that you enable sql queries on the virtual
directory settings.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
> Hello,
> Apologies if this is in the wrong newsgroup...
> I have followed the tutorial in Books Online that is called "Creating the
> nwind Virtual Directory". Everything looks ok but I get an error that
> says: -
> "HTTP Error 404 - File or directory not found. Internet Information
> Services (IIS) when I try to test it using
> http://<IISServer>/nwind?sql=SELECT * FROM Employees FOR XML
> AUTO&root=root
> I have looked all over trying to find out what I have done wrong
> Is there anything else that needs to be set up?
> Thanks in advance
> Brian.
>
|||Hi,
Thanks for replying, I was beginning to despair ;)
I have disabled the friendly errors as you suggested but the 404 page still
doesn't show any more detail than before.
The sql queries were already enabled on the 'nwind
Properties/Settings/Options' tab
Do you have any other suggestions?
Thanks
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
> Could you please disable "Show friendly HTTP error messages" option in
> Advanced tab of IE Options? This should give you more precise error
> messages.
> In the mean time, please ensure that you enable sql queries on the virtual
> directory settings.
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
> news:431ef381$0$21190$db0fefd9@.news.zen.co.uk...
>
|||I am sorry but that's all I could say. It is strange that you cannot see
more detailed error message instead of 404.
Can you access the web server for different directories and pages?
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>
|||I just remember.
If you are using IIS6, you should enable some options on iis configuration
for security reasons:
http://support.microsoft.com/default...&Product=sql2k
If this doesn't work, follow the steps given in this article:
http://sqlxml.org/faqs.aspx?79
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
> Hi,
> Thanks for replying, I was beginning to despair ;)
> I have disabled the friendly errors as you suggested but the 404 page
> still doesn't show any more detail than before.
> The sql queries were already enabled on the 'nwind
> Properties/Settings/Options' tab
> Do you have any other suggestions?
> Thanks
> Brian.
>
> "Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
> news:eTzZVB$sFHA.3604@.tk2msftngp13.phx.gbl...
>
|||Fantastic
I followed the first link and added the SQLXML web service extension, which
cured the problem.
I have now unchecked the 'Allow URL queries'
Thanks for your help
Brian.
"Bertan ARI [MSFT]" <bertan@.online.microsoft.com> wrote in message
news:uQxZ5AFtFHA.2792@.tk2msftngp13.phx.gbl...
>I just remember.
> If you are using IIS6, you should enable some options on iis configuration
> for security reasons:
> http://support.microsoft.com/default...&Product=sql2k
> If this doesn't work, follow the steps given in this article:
> http://sqlxml.org/faqs.aspx?79
> --
> Bertan ARI
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Lost and Confused" <lostandconfused@.nowhere.com> wrote in message
> news:431f5d05$0$17950$db0fefd9@.news.zen.co.uk...
>