安装SQL SERVER 2005 SP3 问题及解决方案

问题一：

MSP Error: 29528 SetInstanceProperty

解决方案：

对于 SQL Server 2005 的独立安装

1. 删除存储 SID 设置的以下注册表子项：
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\SQLGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\AGTGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\FTSGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\ASGroup
   注意：在这些注册表子项中，MSSQL.X 是表示某个特定系统上的对应值的占位符。可以通过检查以下注册表子项下的 MSSQLSERVER 注册表项的值，确定某个特定系统上的 MSSQL.X：

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\

2. 重新安装 SQL Server 2005 Service Pack 或 SQL Server 2005 修补程序包。

参考地址：http://support.microsoft.com/kb/925976

 

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

 

问题二：
MSP Error: 29508 SuperSocketNetLib

解决方案：

1. Click Start, click All Programs, click Accessories, and then click Run.
2. Type regedit, and then click OK.
3. At the User Account Control prompt, click OK.
4. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines.
   
5. Double-click OriginalMachineName, and then change the OriginalMachineName value name to the current server name. (An easy method to find the current server name is to use the hostname command from a command prompt.)
   
6. Click OK.

Once this registry key has been updated you should be able to install SQL 2005 without error.  We recommend that you install your LOB applications and SQL instances on the 2nd server included with SBS 2008 Premium for best performance.

For more information please see: http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx.

参考地下：http://blogs.technet.com/sbs/archive/2009/06/11/error-while-installing-sql-2005-express-on-sbs-2008.aspx