SQL Server Performance

Stored procedure as HTTP endpoint

Discussion in 'SQL Server 2005 General Developer Questions' started by pmijvis, May 19, 2006.

  1. pmijvis New Member

    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,
  2. satya Moderator

    http://www.developer.com/db/article.php/3547866 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.

Share This Page