Using Native XML Web Services in SQL Server 2005

Microsoft SQL Server 2005 provides native XML Web Services through the SQL Server 2005 Database Engine by using the following open standards:

  • Hypertext Transfer Protocol (HTTP)
    As the core protocol behind the World Wide Web, HTTP provides a platform-neutral Web-based exchange of data.

    Important

    HTTP support requires the HTTP listener: Http.sys. Http.sys is available only on Windows Server 2003 and Windows XP Service Pack 2. For more information, see Configuring the HTTP Kernel-Mode Driver (Http.sys).

  • SOAP
    SOAP defines how to use XML and HTTP to access services, objects, and servers regardless of the operating system.

  • Web Services Definition Language (WSDL)
    WSDL is an XML document format that can be used to describe Web-based services.

When you use Native XML Web Services in SQL Server 2005, you can send SOAP messaging requests to an instance of SQL Server 2005 over HTTP to run the following:

  • Transact-SQL batch statements, with or without parameters.
  • Stored procedures, extended stored procedures, and scalar-valued user-defined functions.

In This Section

Topic Description

Native XML Web Services Overview

Compares Native XML Web Services in SQL Server 2005 to Microsoft SQLXML, describes how Native XML Web Services works, and lists some benefits from using it.

Deploying Native XML Web Services

Provides an initial general planning and deployment checklist to refine and follow when evaluating or deploying Native XML Web Services.

Best Practices for Using Native XML Web Services

Provides information and recommendations from the SQL Server product team on best practices to follow for evaluating or deploying Native XML Web Services.

Setting the Server to Listen for Native XML Web Services Requests

Describes how to configure and provision a server computer that is running SQL Server 2005 to help it listen and service HTTP-based requests in a secure manner.

Using WSDL

Describes how WSDL responses are generated and used by Native XML Web Services to support publication of SQL Server programmability that you selectively expose to Web clients.

SOAP Request and Response Message Structure

Details the structure of the various XML-based messages that are used by the SOAP standard.

Working with SOAP Sessions

Describes how SOAP sessions work and can be used to extend multibatch processing to Web-based SQL Server clients.

SQL Server Authentication over SOAP

Describes the choices for how SQL Server authentication can be accommodated in SOAP-based client access scenarios.

Writing Client Applications

Provides an example Web client application in C# and Microsoft Visual Basic to demonstrate how to use Native XML Web Services when you are developing with Microsoft Visual Studio 2005.

Performance Counters for Native XML Web Services

Provides reference information about counters specific to Native XML Web Services that are available for you to use when you monitor performance of your Web applications by using Performance Monitor.

Namespaces Used in SOAP Requests and Responses

Provides reference information about XML namespaces that are predefined for use by Native XML Web Services in SQL Server 2005.

Data Type Mappings in Native XML Web Services

Provides reference information about mapping SQL data types to the XML Schema (XSD) data types that are defined for use in WSDL files that are returned by Native XML Web Services.

Guidelines and Limitations in Native XML Web Services

Documents usage guidelines and feature limitations for Native XML Web Services in SQL Server 2005.

See Also

Concepts

Sample XML Applications

Help and Information

Getting SQL Server 2005 Assistance