Wednesday, December 9, 2009

Install SQL Server Bussiness Intellegent Development Studio

If you have SQL Server Management Studio Express, SQL Server Bussiness Intellegent Development Studio (BIDS) is not installed by default. But you can get BIDS as part of Microsoft SQL Server 2005 Express Edition Toolkit. Microsoft SQL Server 2005 Express Edition Toolkit can be freely downloaded from Microsoft.

Problem:

When installing Microsoft SQL Server 2005 Express Edition Toolkit, the installation failed with the following error message in the log file.

Machine : xxxxxx

Product : MSXML 6 Service Pack 2 (KB954459)

Product Version : 6.20.1099.0

Install : Failed Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_TOT75XRDTW1027R_MSXML6_1.log

Error Number : 1603

The detailed error message in the log indicates

Action start 10:34:08: SkipInstallCA.

This package is not supported on this operating system.

Action ended 10:34:08: SkipInstallCA. Return value 3.

Solution.

First uninstall the existing version of msxml. If fail to uninstall, use Windows Installer CleanUp Utility to clean up msxml6.

After that, re-run SQLEXPR_TOOLKIT.EXE to install BDIS. Everything should be fine.