Stored procedure as HTTP endpoint | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Stored procedure as HTTP endpoint

Hi there, I created a stored procedure which I exposed using a http endpoint.
The sp and endpoint were tested and worked fine.
When transferring these items to our production server the following problem came up:
I cannot connect to the webservice from an external server.
When I openhttp://localhost/endpoint?wsdl on the server itself, everything works fine, I get the XML data.
When I try it to access it from another server it comes up with a username password question. No matter what I enter…it will fail.
The security settings on the SP and Endpoint are OK, otherwise the local attempt would fail as well. The only difference between the test machine and production machine is that the SQL service on the test machine runs as a local system account and the SQL service on the production machine runs under a domain account> What am I missing here ??
Thanks in advance for your responses,
Peter fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.