Xml & Sql

[texas]

To use XML with SQL on a Win2K machine I'm told you need to install IIS. Then I need the Win2K Server CD to install Admin Tools.

The file it says to install is Adminpak.msi.

I guess my question is can I get the Adminpak file from MSFT or is it on the Win2K Pro CD?

If no to both then how can I get it? Short of buying 2000 server.

[Vincent Puglia]

Hi,

While I have no concrete answer:

1) use winExplorer to see if it exists on the CD you have
2) check with http://msdn.microsoft.com

Vinny

[JoshT]

Adminpak.msi is included on the Service Pack CDs (or download the SP, but extract the files rather than install the SP). This is better a better source than the Server CD because it'll have the bug fixes already.

However, you should be able to installer IIS from the Pro CD to get the ISM tool, and running a client-tools only install of SQL Server will install the SQL/IIS/XML manager thing.

Also, you can use the "FOR XML AUTO" or whatever queries without IIS, and the SQL/IIS/XML thing is very easy to configure unsecurely, so read up on it before you start playing.