问题描述:
======
在windows Server 2003 SP2上安装SQL Server 2005 SP3(Cluster)失败
处理方法:
======
通过检查您的SQL Server日志,我发现了日志中的错误记录。
您尝试在active node上安装sql svr 2005 SP3,并在passive node机器上(双结点)报错,在SQL9_Hotfix_KB955706_sqlrun_sql.msp.log中,错误记录如下:
MSI (s) (04!18) [10:58:33:693]: PROPERTY CHANGE: Adding ServiceNameSQL.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'MSSQL$COMPUTER1'.
Using PrevRegRootPath: Software/Microsoft/Microsoft SQL Server/MSSQL.2
GetServiceUserGroup failed for COMPUTER1, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.
这表明您的SQL Server Node的注册表中所记录的由Group生成的SID可能是错误的。