Cannot make a Web Reference to Web Service created (HTTP Endpoint) on SQL 2005 stored procedure

microsoft.public.dotnet.framework.adonet

21 May 2006 8:17 AM

tovbinm

I failed to make a Web Reference to SQL 2005 HTTP endpoint for stored
procedure, It works fine only on locahost.

Whan i surf or make a web reference in VS2005 to
http://locahost/TestWS?wsdl - i get the xml.
When i surf or make a web reference in VS2005 to
http://<sqlservermachinename>/TestWS?wsdl from other machine from the
same domain - i get prompted to username and password.

What useraname/password i need to submit? Domain/SQL user??
How can i control which users can access the endpoint?!

....all the examples i found over the internet were about to access the
endpoint from localhost, so i don't now what to do.

Thanx fro your support.