Configure SQL XML Support...

We have a Windows 2003 Server with SQL Server and IIS. I tried to use the SQ
L
Server Configure SQL XML Support on IIS and can not get it to work.
On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
have no problem..
Are there any articles that can help me with setting up this option on
Windows 2003 Server?
I have deleted the one I created. This one was returning Permission denied.
Newer ones report Page Not Found.
I can now not created a new one with the same name as the first one that I
deleted.
Thanks,
ThomasLLHi
These may help:
http://support.microsoft.com/defaul...kb;en-us;820728
http://msdn.microsoft.com/library/d...9
m4.asp
http://sqlxml.org/faqs.aspx?faq=79
John
"Thomas.LeBlanc@.NoSpam.Com"
<ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
> We have a Windows 2003 Server with SQL Server and IIS. I tried to use the
> SQL
> Server Configure SQL XML Support on IIS and can not get it to work.
> On my local machine, Windows 2000 Profression, SQL Server 200 and IIS, I
> have no problem..
> Are there any articles that can help me with setting up this option on
> Windows 2003 Server?
> I have deleted the one I created. This one was returning Permission
> denied.
> Newer ones report Page Not Found.
> I can now not created a new one with the same name as the first one that I
> deleted.
> --
> Thanks,
> ThomasLL
>|||I am getting a "You are not authrized to view this page" error.
I have set this up on my client machine (Windows 200 Profressional/IIS/SQL
Server 200) and it works. No changes needed.
But on the Windows 2003 Server/IIS/SQL Server 200) I get this error above
"John Bell" wrote:

> Hi
> These may help:
> http://support.microsoft.com/defaul...kb;en-us;820728
> http://msdn.microsoft.com/library/d...br />
59m4.asp
> http://sqlxml.org/faqs.aspx?faq=79
> John
> "Thomas.LeBlanc@.NoSpam.Com"
> <ThomasLeBlancNoSpamCom@.discussions.microsoft.com> wrote in message
> news:F67A6FAD-A1B9-4120-9E2F-C72DDD458CEA@.microsoft.com...
>
>|||Hi
Windows 2003 has a tighter security model and this may be causing a
problem, so make sure that the permissions are correct in IIS and on for
the location.
Also read:
http://support.microsoft.com/defaul...10784&Product=s
ql2k
http://groups-beta.google.com/group...erver.xml/brows
e_thread/thread/e2f12e4e84dea10b/8da2b87b1e0112b2#8da2b87b1e0112b2
John
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Configure SQL XML support in IIS

I have configured SQL XML Support in IIS but still i am not able to Use

http://localhost/ss?Sql=select+*+from+users+for+xml+auto

I am getting Internal Server Error

Hi, if you're sure that the SQL XML Support in IIS has been configured correctly, you can try to add a root element for your output:

http://localhost/ss?sql=select+*+from+users+for+xml+auto&root=users

You can refer to this article for configuring virtual directory for SQLXML:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_2xvd.asp