Deploying Native XML Web Services

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The following table lists the steps that we recommend you follow to enable native XML Web services in SQL Server.

Step	Reference
Learn about Native XML Web Services provided with SQL Server.	Native XML Web Services Concepts
Understand requirements for your application. For example, the following questions are helpful to ask at this step in the process: Is your application for high-volume OLTP or only for occasional use? Do the stored procedures contain lots of business logic?	Best Practices for Using Native XML Web Services
Determine which client operating system types are to be supported. For example, the following questions are helpful to ask at this step in the process: Is the client operating system a Windows-based or an operating system other than Windows? Do you have a heterogeneous environment?	Best Practices for Using Native XML Web Services
Determine whether your application will be deployed for intranet or extranet use?	Guidelines and Limitations in Native XML Web Services Best Practices for Using Native XML Web Services
Choose the authentication type that is best suited for use with your endpoint deployment.	Endpoint Authentication Types
Decide on the correct WSDL strategy for your environment: default, simple, custom, or none.	Using WSDL
Create HTTP endpoints to allow the instance of SQL Server listen to HTTP requests.	Setting the Server to Listen for Native XML Web Services Requests CREATE ENDPOINT (Transact-SQL)
Grant permissions to endpoints.	GRANT Endpoint Permissions (Transact-SQL)
Expose stored procedures or user-defined functions as Web methods.	Exposing SQL Programmability to the Web
Test the default WSDL response from the endpoint.	Default WSDL Simple WSDL
(optional) Update or re-create endpoints as needed.	ALTER ENDPOINT (Transact-SQL) DROP ENDPOINT (Transact-SQL)

See Also

Other Resources

Native XML Web Services Concepts