2005 SP2 woes

Hello,

I've run into a problem trying to install SP2 for SQL2005 on a Server 2003 system. I tried to troubleshoot this myself but the logs are just not verbose enough. The box was just rebuilt with Server 2003, then SP2 for 2003 was immediately applied. SQL2005 was then installed. In my attempt to install SP2 for SQL2005, the following errors occured:

Summary.txt

-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

-
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

-

Hotfix.log

04/11/2007 09:26:13.317 Locked file: Checking for locked files
04/11/2007 09:26:16.692 Attempting to pause the 32 bit ngen queue
04/11/2007 09:26:16.848 Installing product: SQL9
04/11/2007 09:26:16.848 Installing instance: MSSQLSERVER
04/11/2007 09:26:16.848 Installing target: MINKE
04/11/2007 09:26:16.848 Installing file: sqlrun_sql.msp
04/11/2007 09:26:16.864 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
04/11/2007 09:26:16.864 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:16.864 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:25.411 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

04/11/2007 09:26:26.239 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:26.255 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:26.255 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:26.911 Copy Engine: Error, unable to install MSP file: d:\0a41f59141805a7af3438a\HotFixSQL\Files\sqlrun_sql.msp
04/11/2007 09:26:26.911 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:26.911 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
04/11/2007 09:26:27.286 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param2 = 0x7358
04/11/2007 09:26:27.286 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param4 = 0x7358
04/11/2007 09:26:27.286 Watson: Param5 = sqlca\sqlcax.cpp@.1223
04/11/2007 09:26:27.286 Watson: Param6 = Unknown
04/11/2007 09:26:27.286 Watson: Param7 = SQL9
04/11/2007 09:26:27.286 Watson: Param8 = Hotfix@.
04/11/2007 09:26:27.286 Watson: Param9 = x86
04/11/2007 09:26:27.286 Watson: Param10 = 3042
04/11/2007 09:26:27.301 Installed product: SQL9
04/11/2007 09:26:27.301 Installing product: OLAP9
04/11/2007 09:26:27.301 Installing instance: MSSQLSERVER
04/11/2007 09:26:27.301 Installing target: MINKE
04/11/2007 09:26:27.317 Installing file: sqlrun_as.msp
04/11/2007 09:26:27.317 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
04/11/2007 09:26:27.317 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:27.317 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:32.020 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

04/11/2007 09:26:32.552 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:32.567 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:32.567 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:33.348 Copy Engine: Error, unable to install MSP file: d:\0a41f59141805a7af3438a\HotFixAS\Files\sqlrun_as.msp
04/11/2007 09:26:33.348 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:33.348 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
04/11/2007 09:26:33.755 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param2 = 0x7358
04/11/2007 09:26:33.755 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param4 = 0x7358
04/11/2007 09:26:33.755 Watson: Param5 = sqlca\sqlcax.cpp@.1223
04/11/2007 09:26:33.755 Watson: Param6 = Unknown
04/11/2007 09:26:33.755 Watson: Param7 = OLAP9
04/11/2007 09:26:33.755 Watson: Param8 = Hotfix@.
04/11/2007 09:26:33.755 Watson: Param9 = x86
04/11/2007 09:26:33.755 Watson: Param10 = 3042
04/11/2007 09:26:33.770 Installed product: OLAP9
04/11/2007 09:26:33.770 Hotfix package completed
04/11/2007 09:26:33.770 Attempting to continue the 32 bit ngen queue

Any help would be appreciated. Thanks in advance.

Regards,

Nathan

Found the fix:

http://support.microsoft.com/default.aspx/kb/925976/

Nathan wrote:

Hello,

I've run into a problem trying to install SP2 for SQL2005 on a Server 2003 system. I tried to troubleshoot this myself but the logs are just not verbose enough. The box was just rebuilt with Server 2003, then SP2 for 2003 was immediately applied. SQL2005 was then installed. In my attempt to install SP2 for SQL2005, the following errors occured:

Summary.txt

-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

-
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

-

Hotfix.log

04/11/2007 09:26:13.317 Locked file: Checking for locked files
04/11/2007 09:26:16.692 Attempting to pause the 32 bit ngen queue
04/11/2007 09:26:16.848 Installing product: SQL9
04/11/2007 09:26:16.848 Installing instance: MSSQLSERVER
04/11/2007 09:26:16.848 Installing target: MINKE
04/11/2007 09:26:16.848 Installing file: sqlrun_sql.msp
04/11/2007 09:26:16.864 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
04/11/2007 09:26:16.864 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:16.864 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:25.411 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

04/11/2007 09:26:26.239 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:26.255 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:26.255 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:26.911 Copy Engine: Error, unable to install MSP file: d:\0a41f59141805a7af3438a\HotFixSQL\Files\sqlrun_sql.msp
04/11/2007 09:26:26.911 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:26.911 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
04/11/2007 09:26:27.286 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param2 = 0x7358
04/11/2007 09:26:27.286 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param4 = 0x7358
04/11/2007 09:26:27.286 Watson: Param5 = sqlca\sqlcax.cpp@.1223
04/11/2007 09:26:27.286 Watson: Param6 = Unknown
04/11/2007 09:26:27.286 Watson: Param7 = SQL9
04/11/2007 09:26:27.286 Watson: Param8 = Hotfix@.
04/11/2007 09:26:27.286 Watson: Param9 = x86
04/11/2007 09:26:27.286 Watson: Param10 = 3042
04/11/2007 09:26:27.301 Installed product: SQL9
04/11/2007 09:26:27.301 Installing product: OLAP9
04/11/2007 09:26:27.301 Installing instance: MSSQLSERVER
04/11/2007 09:26:27.301 Installing target: MINKE
04/11/2007 09:26:27.317 Installing file: sqlrun_as.msp
04/11/2007 09:26:27.317 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
04/11/2007 09:26:27.317 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:27.317 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:32.020 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

04/11/2007 09:26:32.552 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:32.567 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
04/11/2007 09:26:32.567 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:33.348 Copy Engine: Error, unable to install MSP file: d:\0a41f59141805a7af3438a\HotFixAS\Files\sqlrun_as.msp
04/11/2007 09:26:33.348 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:33.348 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
04/11/2007 09:26:33.755 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param2 = 0x7358
04/11/2007 09:26:33.755 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param4 = 0x7358
04/11/2007 09:26:33.755 Watson: Param5 = sqlca\sqlcax.cpp@.1223
04/11/2007 09:26:33.755 Watson: Param6 = Unknown
04/11/2007 09:26:33.755 Watson: Param7 = OLAP9
04/11/2007 09:26:33.755 Watson: Param8 = Hotfix@.
04/11/2007 09:26:33.755 Watson: Param9 = x86
04/11/2007 09:26:33.755 Watson: Param10 = 3042
04/11/2007 09:26:33.770 Installed product: OLAP9
04/11/2007 09:26:33.770 Hotfix package completed
04/11/2007 09:26:33.770 Attempting to continue the 32 bit ngen queue

Any help would be appreciated. Thanks in advance.

Regards,

Nathan

|||

Nathan,

Thanks for following up your own post. It prevents others from wasting their time trying to help you after you have solved the problem, and it helps others when you share your solution.