Compartilhar via

On SQL Server 2005 Web Service integration

  • Artigo

My Cork and Galway SQL Server 2005 presentations featured thoughtful questions on Web Service Endpoint integration that I wasn't able to answer completely (and occasionally at all!).  That prompted a thorough, if belated, literature search, which I'll summarize here:

On SQL Server 2005 Web Service Hosting

SQL Server 2005’s Web Service hosting does not use IIS. In fact, here is an article at devx.com that summarizes how the SQL Server Web Service Endpoints are implemented, and indicates how they contrast with SQLXML in SQL Server 2000. (Also see the MSDN Library article linked below.)

On SQL Server 2005 Web Service WS-Security

HTTP Endpoints support the following standard authentication mechanisms: Basic, Digest, Integrated (NTLM, Kerberos), and SQL Auth. If you’re interested in a perfect two-paragraph summary, search for “Authentication and Security” on this MSDN Library page: Overview of Native XML Web Services for Microsoft SQL Server 2005.

 

Finally, on SQL Server 2005 Server-Side Programmability in General

The answers you seek are probably here on the SQL2005 site. They have excellent resources available, so SELECT * from there if you want to know more...

Comments

  • Anonymous
    October 19, 2005
    Thanks for the answers!

  • Anonymous
    October 19, 2005
    No problem! Thanks for asking the tough questions!! :)