We help IT Professionals succeed at work.

How to know if SQLXML4 is installed on SQL Server 2008.

Hi All,

Its regarding one of my client's application server. It is running the following.

OS: Windows Server 2008 Enterprise x64 Edition (Version 6.0. Build 6001. Service pack 1)
SQL: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)   Jul  9 2008 14:17:44   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

How to check if SQLXML4 is installed and if not how to install it myself or should I ask the client to do it?

Please suggest.



Watch Question


Correction - Its a database server.

The default install location is here %PROGRAMFILES%\SQLXML 4.0\ so that would be an easy check SQLXML. To quote the current download
"Before SQL Server 2008, SQLXML 4.0 was released with SQL Server and was part of the default installation of all SQL Server versions except for SQL Server Express. Starting with SQL Server 2008, the latest version of SQLXML (SQLXML 4.0 SP1) is no longer included in SQL Server." heres the link http://msdn.microsoft.com/en-us/library/ms171744.aspx

As to whether you install it or not would depend on your relationship with the client and thats something only you know. Unless I am explicitly contracted to maintain servers its not something I want to do, it avoids finger pointing.

Hope that helps
Just as an additional note pay careful attention to the notes about 32bit vs 64bit install.