我的电脑原本就有Sql Server 2005 Express Edition。由于最近需要用到express edition所没有的integration service,所以需要另外安装Sql Server 2005 Developer Edition。就在安装以后遇见了不少问题,今天就先来分享其中一个。待我完全解决之后再来做个整理。
问题:安装 Sql Server 2005 Service Pack 1 时有 Unable to install Windows Installer MSP file的讯息。
解决:
1. Export the MSIRefCount\Uninstall registry entry. To do this, follow these steps:
a. Click Start, click Run, type Regedit, and then click OK to open Registry Editor.
b. In Registry Editor, locate the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount
c. In the right panel, click the Uninstall registry entry.
d. On the File menu, click Export.
e. Specify a location and a file name, and then click Save.
Notice that the value of the MSIRefCount\Uninstall registry entry contains references to all the components that are dependant on the SQL Server Setup Support files.
2. Uninstall the existing SQL Server Setup Support files by using Add or Remove Programs in Control Panel.
Note When you try to uninstall the SQL Server Setup Support files, you receive a warning message that resembles the following:
Warning 26002. The following products(s) is dependent on Microsoft SQL Server Setup Support Files (English). If you uninstall Microsoft SQL Server Setup Support Files (English), they will be broken. Please uninstall those product(s) first. Do you want to go ahead to uninstall Microsoft SQL Server Setup Support Files (English) anyway?
When you receive this warning message, click Yes.
3. Reinstall the 9.00.1399.06 version of the SQL Server Setup Support files. To do this, follow these steps:
a. Open the Servers\Setup folder from the SQL Server 2005 installation media.
Note If you use the SQL Server 2005 installation CDs, not the DVD, to install SQL Server 2005, the Setup folder that you must access is on the Servers CD.
b. Double-click the SqlSupport.msi file to install the 9.00.1399.06 version of the SQL Server Setup Support files.
c. Follow the installation wizard through the rest of the installation processes.
4. Import the registry setting through the registry file that you saved in step 1.
5. Reinstall SQL Server 2005 SP1.
Reference: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918357