http://www.windows.totalroute.net Blog About Windows Servers and Security Mon, 05 Nov 2007 22:15:01 +0000 http://backend.userland.com/rss092 en SQL SERVER AS A PLATFORM FOR WEB SERVICES general, authentication is providing information, be it a user ID and password or a token containing a Kerberos ticket, to identify yourself to the application and prove that you are who you claim to be. Once you have ... http://www.windows.totalroute.net/2007/11/05/sql-server-as-a-platform-for-web-services-4/ SECURITY CHOICES AND XML WEB SERVICES SQLXML 3.0 Functionality In SQLXML 3.0, the equivalent functionality would be defined by using the IIS Virtual Directory Management for SQL Server GUI tool and adding a new virtual directory. Because we are using native HTTP ... http://www.windows.totalroute.net/2007/11/05/security-choices-and-xml-web-services-sqlxml-30/ SQL SERVER AS A PLATFORM FOR WEB SERVICES If you specify + (plus sign), it means that you want to listen on all possible host names for the machine. * is the default. PATH The path on the Web server that users connect ... http://www.windows.totalroute.net/2007/11/04/sql-server-as-a-platform-for-web-services-3/ PARAMETERS THAT RELATE TO SERVING HTTP Defining whether you can invoke specific procedures, arbitrary batches, or both Defining the exact format of the SOAP message Endpoint State First, we d like to point out that no HTTP ... http://www.windows.totalroute.net/2007/11/04/parameters-that-relate-to-serving-http-defining/ SQL SERVER AS A PLATFORM FOR WEB SERVICES time correlate these DDL statements with the COM object model that you would be using if you use SQLXML 3.0. The complete syntax for cataloging an HTTP endpoint definition in Transact-SQL follows. CREATE ENDPOINT endPointName [AUTHORIZATION ... http://www.windows.totalroute.net/2007/11/03/sql-server-as-a-platform-for-web-services-2/ HTTP ENDPOINT DECLARATION program that could consume WSDL to know how to communicate with SQL Server. All the SQLXML 3.0 capabilities are available to SQL Server 2005 and SQL Server 2000. But if you have installed SQL Server 2005 on the Windows 2003 ... http://www.windows.totalroute.net/2007/11/03/http-endpoint-declaration-program-that-could-consume-wsdl/ SQL SERVER AS A PLATFORM FOR WEB SERVICES required for full functionality. Not only is TDS a proprietary protocol, but it needs some special firewall configuration to work over the Internet. A specific network port (port 1433 in the default case) needs to be open on ... http://www.windows.totalroute.net/2007/11/02/sql-server-as-a-platform-for-web-services/ 10 SQL Server as a Platform for Web Services SQLXML 3.0 INTRODUCED the concept of exposing SQL Server as a Web Service, through the use of a special Internet Services API (ISAPI) DLL running under Internet Information Server. SQL Server 2005 moves ... http://www.windows.totalroute.net/2007/11/02/10-sql-server-as-a-platform-for-web/ WHERE ARE WE? well as other, physical optimizations such as types of indexes. With an XML data type, the possibility of strong typing through XML Schemas, and a query language that allows optimizations based on strong typing, XQuery users will most likely experience the same ... http://www.windows.totalroute.net/2007/11/01/where-are-we-well-as-other-physical-optimizations/ XML QUERY LANGUAGES: XQUERY AND XPATH Even though the XML instance that is input to an XML function can be typed or untyped, remember that the result of an xml.query function is always an untyped XML instance. Typed XML should always be used, if possible, to ... http://www.windows.totalroute.net/2007/11/01/xml-query-languages-xquery-and-xpath-even-though/