Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Native XML Support with Sql Server 2005 - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Native XML Support with Sql Server 2005

I was just reading through the December CTP Help File for Sql Server 2005.  I noticed that Native XML support in Sql Server 2005 will require

  • Windows Server 2003.
  • Windows XP w/ SP2.

This requirement is due to the need for http.sys, which provides the http listener functionality to Sql Server 2005.

Update 12/23/2004: As you can see from the feedback, there is some good input from the folks @ Microsoft about this.  :-)  I had pulled this from the December CTP help file thinking that the requirement was a bit strange.  My guess is that this is a gray area in the help file.  XML in and of itself would seem to have no need for the Http.sys file.  The need for Http.sys would be from the ability to listen for a SOAP request.

Posted: Dec 20 2004, 02:45 PM by Wallym | with 8 comment(s)
Filed under: ,

Comments

Michael Rys said:

This is not correct. The native XML support has no dependency on http.sys and does not need Windows Server 2003 or XP/SP2.

What needs http.sys is the HTTP/SOAP stack.
# December 22, 2004 8:05 PM

TrackBack said:

XML Support in SQL Server 2005 has no dependency on http.sys
# December 22, 2004 8:10 PM

TrackBack said:

# December 22, 2004 8:32 PM

Wallym said:

I guess it is an error in the Sql Server 2005 documentation. I pulled the comment from the Sql Server 2005 December CTP BOL. I'm going to check this when I get to the office in the morning. Hmmm, very interesting..........
# December 22, 2004 9:43 PM

Wallym said:


here is the url in the december ctp of Sql Server 2k5
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ed5c0445-1534-4373-9616-c8e5a1663479.htm

Requirements for Native XML Support
Native HTTP Support requires the HTTP listener (Http.sys) which is only provided with the following Windows environments:

Windows Server 2003
Windows XP SP2

My gut says that Michael knows more about this than I and that it is a problem in the documentation at this time.

Wally
# December 23, 2004 9:51 AM

Jacobcy said:

Wally,

I don't have the documentation that comes with the CTP of SQL Server 2k5, but it sounds like what Srik Raghavan, lead program manager, discusses during the Native XML *Web Services* webcast a couple weeks back (check out the on-demand webcast here: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032263308&EventCategory=5). To support native web services you do need http.sys, found in either operating system listed above. Note that this is separate from the native XML data type, which has no similar requirement.

Cheers,
Jacobcy
# December 23, 2004 8:32 PM

TrackBack said:

# December 24, 2004 12:07 AM

DirkM said:

There's now a doc bug filed to clarify this in the topic.
# December 24, 2004 1:16 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)