locked
SOAP endpoint not returning wsdl RRS feed

  • Question

  • I have created a SOAP Endpoint using the code below. When I type this URL http://mnepbtsql01-d/EAE?wsdl into my browser, I don't get the WSDL back. The Endpoint get's created because I see it in SSMS and the namespace gets registered because I see it in Event Viewer.  Does anyone have a suggestion as to what's happening?

    use enhanced_application_entry

    go

    IF EXISTS

    (

    SELECT name from sys.http_endpoints

    WHERE name = 'Applicant_Administration'

    )

    DROP ENDPOINT Applicant_Administration

    GO

     

    CREATE ENDPOINT Applicant_Administration

    STATE = STARTED

    AS HTTP

    (

    PATH = '/EAE',

    AUTHENTICATION = (KERBEROS),

    PORTS = (CLEAR),

    SITE = 'MNEPBTSQL01-D'

    )

    FOR SOAP

    (

    WEBMETHOD 'ApplicantAdministrationReturn'

    (NAME='Enhanced_Application_Entry.dbo.cxml_Applicant_Admin_Return_Profile'),

    WEBMETHOD 'http://MNEPBTSQL01-D:80/SQL2005/EAE/'.'udf_NMVLU_2' (NAME='Enhanced_Application_Entry.dbo.udf_NMVLU_2'),

    BATCHES = Enabled,

    WSDL = DEFAULT,

    DATABASE = 'Enhanced_Application_Entry',

    NAMESPACE = 'http://MNEPBTSQL01-D:80/SQL2005/EAE'

    )

    go

    use master

    go

    GRANT CONNECT ON ENDPOINT::Applicant_Administration TO [corp\mmastro]

    Thursday, October 26, 2006 2:21 PM

Answers

  • For testing purposes I recommend changing the AUTHENTICATION setting from KERBEROS to NTLM.  The main reason is that in order for KERBEROS to work properly, you will need to make sure that the SPN is setup correctly.  For details on how to setup KERBEROS SPN please refer to http://msdn2.microsoft.com/en-us/library/ms178119.aspx

    Internet Explorer is picky about its support for KERBEROS.  I'm not aware of all the issues, but is likely the cause of your blank page.
    Everything else you've have above looks correct.

    Jimmy

    Thursday, October 26, 2006 5:23 PM