Re: Accessing SQL via http

Tech-Archive recommends: Speed Up your PC by fixing your registry

I just remember.

If you are using IIS6, you should enable some options on iis configuration
for security reasons:
http://support.microsoft.com/default.aspx?scid=kb;en-us;810784&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@xxxxxxxxxxx> wrote in message
news:431f5d05$0$17950$db0fefd9@xxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:eTzZVB$sFHA.3604@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxx> wrote in message
>> news:431ef381$0$21190$db0fefd9@xxxxxxxxxxxxxxxxx
>>> 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.
>>>
>>
>>
>
>


.