Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 http query authentication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-09 : 08:04:57
traey writes "I am using MS SQLServer 2000. on a windows 2000 server. I am executing a stored query, which returns XML results, via URL and would like to be able to authenticate using sql's user accounts. I understand how to do this with the pop-up challenge; however, I would like to send this URL from a flash movie and would prefer not to require the user to stop and enter a username and password at that point in time. Is there a way to send the u/p via the URL, preferably in a "post" header? Any help or suggestions would be appreciated.
Thanks.
Traey"

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-08-09 : 08:50:10
SQLXML access is hardcoded into the virtual directory when you set it up whether it be SQL or NT Authentication. There should be no need to supply authentication. Also it is not advised to use POST HTTP queries in a production environment - is there any reason you can't use templates ?


HTH
Jasper Smith
Go to Top of Page
   

- Advertisement -