I ran into a handful of issues applying SQL Server 2005 SP1 to my Development SQL Server.
The first issue was an "Unable to install Windows Installer MSP file" error:
After some searching, I found this good MSDN forum post that helped with this error. Here are the steps I took to address it with screenshots.
1. Open RegEdit and navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount key:
2. Select the MSIRefCount key. Click File, then Export:
3. Select a Path and Filename to store the contents of this key and click the Save button:
4. On the SQL Server 2005 installation media, locate the SQLSupport.msi file. RIght-click the file and click Uninstall:
NOTE: There is no indication the uninstallation succeeds. You may or may not see a brief dialog with a progress bar, but there is no status message at the end of the uninstall.
5. Re-install the SQLSupport.msi file by again right-clicking the file. This time, click Install to install the file:
6. Return to RegEdit. Click File, then Import:
7. Navigate to the file you exported earlier:
8. Click Open. If successful, a dialog will display status:
This got me over the first hurdle, but I hit another... more in Part 2.
Technorati Tags: SSIS Sql Server SP1 Developer Community Richmond Virginia