Frequently Asked Questions About SOAP Sessions

The following answers to several frequently asked questions might help you resolve common issues that you may experience when you work with SOAP sessions.

Questions and Answers

Why am I getting either no SOAP response from the server or a "bad session ID" response?

First, make sure that the names of optional header elements or attributes used to initiate a session are correct. Specifically, verify that they are using the correct mixed case names such as sqlSession and sessionId. If the case is incorrect, the server will either ignore the header or return a bad session ID fault in the SOAP initiation response.

Why do I see a SOAP fault in the response that indicates the session I requested is disabled?

Make sure that the HTTP endpoint has had the SESSIONS property enabled for its SOAP properties. By default, sessions are not enabled when an HTTP endpoint is created, unless you explicitly set SESSIONS=ENABLED in the SOAP-based options for the endpoint by using either CREATE ENDPOINT or ALTER ENDPOINT.

I am trying to use a SOAP session with a WSDL request, but it does not work. Why?

SOAP sessions support is not available for Web Services Definition Language (WSDL) requests. For more information about WSDL, see Using WSDL.

See Also

Concepts

How SOAP Sessions Support Works

Other Resources

Troubleshooting the Database Engine
Working with SOAP Sessions

Help and Information

Getting SQL Server 2005 Assistance