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.Hi
You did change <IISServer> for the actual server name?
If all the properties look ok, then you may want to try restarting the web
server to see if that helps.
Make sure that you can ping the database server from the web server.
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f2057$0$30311$da0feed9@.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 John,
Yes, I amended "<IISServer>" to "myserv"
Excuse my ignorance but I'm not sure about restarting the web server. Do you
mean the 'World Wide Web Publishing Service' in 'Services'?
Thanks for replying
Brian.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Hi
> You did change <IISServer> for the actual server name?
> If all the properties look ok, then you may want to try restarting the web
> server to see if that helps.
> Make sure that you can ping the database server from the web server.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f2057$0$30311$da0feed9@.news.zen.co.uk...
>|||Sorry, I forgot to mention that I'm trying to set this up on our server.
The database is on 1 drive, the virtual directory has been set up and I'm
trying to retrieve the data using the same server.
So, no web hosting/external parties as everything is internal.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Hi
> You did change <IISServer> for the actual server name?
> If all the properties look ok, then you may want to try restarting the web
> server to see if that helps.
> Make sure that you can ping the database server from the web server.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f2057$0$30311$da0feed9@.news.zen.co.uk...
>|||Hi
That was the reboot/restart option! Could do stop/start IIS from Internet
Information Services on the Administrators menu.
If all directories/permissions exist and are correct, you may want to try
removing the directory and re-creating it. Check the IIS logs to see if
there is more information.
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431f6810$0$3556$da0feed9@.news.zen.co.uk...
> Hi John,
> Yes, I amended "<IISServer>" to "myserv"
> Excuse my ignorance but I'm not sure about restarting the web server. Do
> you mean the 'World Wide Web Publishing Service' in 'Services'?
> Thanks for replying
> Brian.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:umSswh$sFHA.4076@.TK2MSFTNGP11.phx.gbl...
>|||Hi John,
I had also posted the problem in the sqlserver.xml newsgroup. One suggestion
was to add a web service extension called SQLXML.
http://support.microsoft.com/defaul...4&Product=sql2k
This worked perfectly :
Thanks for your help
Brian.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uZNNK2EtFHA.3236@.TK2MSFTNGP14.phx.gbl...
> Hi
> That was the reboot/restart option! Could do stop/start IIS from Internet
> Information Services on the Administrators menu.
> If all directories/permissions exist and are correct, you may want to try
> removing the directory and re-creating it. Check the IIS logs to see if
> there is more information.
> John
> "Lost and Confused" <lostand@.nowhere.com> wrote in message
> news:431f6810$0$3556$da0feed9@.news.zen.co.uk...
>|||Hi
Yes that is a pre-requisite!
John
"Lost and Confused" <lostand@.nowhere.com> wrote in message
news:431ffdb2$0$306$da0feed9@.news.zen.co.uk...
> Hi John,
> I had also posted the problem in the sqlserver.xml newsgroup. One
> suggestion was to add a web service extension called SQLXML.
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;810784&Product=sql2k[/ur
l]
> This worked perfectly :
> Thanks for your help
> Brian.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uZNNK2EtFHA.3236@.TK2MSFTNGP14.phx.gbl...
>