Helaas...deze pagina is niet beschikbaar in het Nederlands. Klik hier om terug te gaan of lees verder in het Engels.

Providing SQL data as a web service using SQL Server 2005 Native Web Services

Area: SQL Server 2005 | Level: Intermediate / Advanced

One of the more interesting features introduced in SQL Server 2005 is Native Web Services. This feature makes it possible to expose SQL data to any client or application capable of sending a SOAP request.

I say “expose”, but in fact any data you make available in this way is well protected, with several different layers of permissions that need to be applied before data becomes available to the web service consumer.

In this article, I’ll address the steps necessary to make the results of a SQL stored procedure available to a Window-authenticated client for a named user on your own domain. A future article will describe how to call this data from an ASP.NET application, while another article will show you how to set up a SQL native web service using SSL certificates and SQL authentication to expose data outside your firewall to non-domain or anonymous users... (continues as PDF)

Part 2 - "Consuming a SQL 2005 Native Web Service from an ASP.NET application" - is available here...

Download the entire article as a PDF file...
Get a free PDF reader here...