SOAP Extension Headers
A request sent to an instance of SQL Server 2005 by using HTTP and SOAP can contain optional headers in the SOAP envelope that will modify how the request is executed. Similarly, sometimes, the instance of SQL Server can return additional SOAP header information for specific activities, such as database mirroring. The following are the optional headers:
- SQL optional headers
- The Web Services Security (WS-Security) header
SQL Optional Headers
These optional headers for SQL Server 2005 have been added to HTTP SOAP support primarily to achieve parity with options that are available in traditional SQL data access over network connections where the Tabular Data Stream (TDS) protocol is being used.
Unless otherwise specified in this section, each of these optional headers use the namespace URI of "https://schemas.microsoft.com/sqlserver/2004/SOAP/Options" and are associated with the sqloptions namespace prefix which is declared in the following way for each header:
xmlns:sqloptions="https://schemas.microsoft.com/sqlserver/2004/SOAP/Options"
The following table lists all SQL optional headers that are available for use in SOAP request messaging under SQL Server 2005.
| Header | Description |
|---|---|
Enables the client to specify an application name for use. |
|
Enables the client to specify a client interface for use. |
|
Enables the client to specify a client network ID for use in SQL login. |
|
Enables the client to specify a client process ID for use. |
|
Used by the server to return information to a database mirror partner. |
|
Enables the client to specify which environment change notifications it wishes to receive from the server. |
|
Enables the client to specify a host name for use. |
|
Enables the client to specify the initial database for use. |
|
Enables the client to specify the initial language for use. |
|
Enables the client to request a notification from the server. |
|
Enables the client to request a SOAP session. |
The WS-Security Header
The Web Services Security (WS-Security) header is supported for use with SQL Server 2005 to specify user name and password credentials for use in SQL Server authentication. For more information about the WS-Security header as it is supported for use in SQL Server 2005, see SQL Server Authentication over SOAP.
WS-Security is based on an open standard that has been submitted to the Organization for the Advancement of Structured Information Standards (OASIS). For more information about the WS-Security standard architecture, visit the OASIS Web site at http://www.oasis-open.org.
See Also
Reference
Namespaces Used in SOAP Requests and Responses
SOAP Request Message Structure
Adding SOAP Headers to Client Applications
Concepts
Best Practices for Using Native XML Web Services