sp2 install fails - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

sp2 install fails

Author

Topic

triton45
Starting Member

16 Posts

Posted - 2007-05-18 : 11:02:24

win2k3 running sql 2k5

The sp2 fails on database services and analysis services, but completes everything else.

Any suggestions would be appreciated.

Andy

Below is an excerpt from the log:
05/18/2007 10:41:13.620 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
05/18/2007 10:41:13.620 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:41:13.620 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:25.041 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

05/18/2007 10:41:25.463 MSP returned 1603: A fatal error occurred during installation.
05/18/2007 10:41:25.510 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:41:25.510 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:26.385 Copy Engine: Error, unable to install MSP file: c:\f6dc3a60067184b3ad32b830c4e7b2\HotFixSQL\Files\sqlrun_sql.msp
05/18/2007 10:41:26.385 The following exception occurred: Unable to install Windows Installer MSP file Date: 05/18/2007 10:41:26.385 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
05/18/2007 10:41:26.885 Watson: Param1 = SetInstanceProperty
05/18/2007 10:41:26.885 Watson: Param2 = 0x7358
05/18/2007 10:41:26.885 Watson: Param3 = SetInstanceProperty
05/18/2007 10:41:26.901 Watson: Param4 = 0x7358
05/18/2007 10:41:26.901 Watson: Param5 = sqlca\sqlcax.cpp@1223
05/18/2007 10:41:26.901 Watson: Param6 = Unknown
05/18/2007 10:41:26.901 Watson: Param7 = SQL9
05/18/2007 10:41:26.901 Watson: Param8 = Hotfix@
05/18/2007 10:41:26.901 Watson: Param9 = x86
05/18/2007 10:41:26.901 Watson: Param10 = 3042
05/18/2007 10:41:26.901 Installed product: SQL9
05/18/2007 10:41:26.901 Installing product: OLAP9
05/18/2007 10:41:26.901 Installing instance: MSSQLSERVER
05/18/2007 10:41:26.916 Installing target: VTHSQLTEST
05/18/2007 10:41:26.916 Stopping service: MSSQLServerOLAPService
05/18/2007 10:41:33.948 Stopped service: MSSQLServerOLAPService
05/18/2007 10:41:33.963 Installing file: sqlrun_as.msp
05/18/2007 10:41:33.963 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
05/18/2007 10:41:33.963 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:41:33.963 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:38.697 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

05/18/2007 10:41:39.041 MSP returned 1603: A fatal error occurred during installation.
05/18/2007 10:41:39.072 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:41:39.072 Registry: Cannot read registry key value "Debug"
05/18/2007 10:41:39.963 Copy Engine: Error, unable to install MSP file: c:\f6dc3a60067184b3ad32b830c4e7b2\HotFixAS\Files\sqlrun_as.msp
05/18/2007 10:41:39.963 The following exception occurred: Unable to install Windows Installer MSP file Date: 05/18/2007 10:41:39.963 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
05/18/2007 10:41:40.369 Watson: Param1 = SetInstanceProperty
05/18/2007 10:41:40.369 Watson: Param2 = 0x7358
05/18/2007 10:41:40.369 Watson: Param3 = SetInstanceProperty
05/18/2007 10:41:40.369 Watson: Param4 = 0x7358
05/18/2007 10:41:40.369 Watson: Param5 = sqlca\sqlcax.cpp@1223
05/18/2007 10:41:40.369 Watson: Param6 = Unknown
05/18/2007 10:41:40.369 Watson: Param7 = OLAP9
05/18/2007 10:41:40.369 Watson: Param8 = Hotfix@
05/18/2007 10:41:40.369 Watson: Param9 = x86
05/18/2007 10:41:40.369 Watson: Param10 = 3042
05/18/2007 10:41:40.369 Installed product: OLAP9
05/18/2007 10:41:40.369 Installing product: RS9
05/18/2007 10:41:40.369 Installing instance: MSSQLSERVER
05/18/2007 10:41:40.369 Installing target: VTHSQLTEST
05/18/2007 10:41:40.369 Stopping service: ReportServer
05/18/2007 10:41:43.416 Stopped service: ReportServer
05/18/2007 10:41:43.416 Installing file: sqlrun_rs.msp
05/18/2007 10:41:43.463 Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
05/18/2007 10:41:43.463 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:41:43.463 Registry: Cannot read registry key value "Debug"
05/18/2007 10:43:34.572 MSP returned 0: The action completed successfully.
05/18/2007 10:43:34.572 Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
05/18/2007 10:43:34.572 Registry: Cannot read registry key value "Debug"
05/18/2007 10:43:34.572 Copy Engine: Installed file: c:\f6dc3a60067184b3ad32b830c4e7b2\HotFixRS\Files\sqlrun_rs.msp
05/18/2007 10:43:34.587 Restarting RS Service ReportServer since it was previously running
05/18/2007 10:43:34.587 Starting service: ReportServer

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-18 : 11:50:03

I had several sp2 install failures, rebooting then trying again solved all of them.

mlahrkamp
Starting Member

2 Posts

Posted - 2007-06-04 : 12:30:15

I have the same problem with the same log results. Rebooting dodn't solve anything. Any other ideas?

Mike

Mike

triton45
Starting Member

16 Posts

Posted - 2007-06-04 : 12:50:55

I was unable to find the problem and had to rebuild from scratch. This was only a development server, but make me hesitant about applying the sp to the production server.

Andy

mlahrkamp
Starting Member

2 Posts

Posted - 2007-06-04 : 16:10:05

OK... found it after 8 hours... KB925976 (http://support.microsoft.com/kb/925976).

Mike

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources