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
