error upgrading to sql2008r2 sp2

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 2008 Forums

SQL Server Administration (2008)

error upgrading to sql2008r2 sp2

Author

Topic

james_wells
Yak Posting Veteran

55 Posts

Posted - 2013-05-21 : 05:27:44

---current version-----

SQLServer2008R2SP2-KB2630455-x64-ENU

Microsoft SQL Server 2008 R2 (SP2) - 10.50.3720.0 (X64) Apr 27 2012 13:51:37 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

--- upgrading to --------
SQLServer2008R2SP2-KB2630458-x64-ENU
which should be 10.50.4000.0

2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2013-05-21 09:32:56 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130521_092633\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2013-05-21 09:32:57 Slp: Unrecognized service name 'ReportServer$SHPT$2008'
2013-05-21 09:32:57 Slp: Watson bucket for exception based failure has been created
2013-05-21 09:32:57 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2013-05-21 09:32:57 Slp: Sco: Attempting to open registry subkey
2013-05-21 09:32:57 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2013-05-21 09:32:57 Slp: Sco: Attempting to get registry value DW0201
2013-05-21 09:33:37 Slp: Submitted 1 of 1 failures to the Watson data repository
2013-05-21 09:33:37 Slp:
2013-05-21 09:33:37 Slp: ----------------------------------------------------------------------
2013-05-21 09:33:37 Slp:
2013-05-21 09:33:37 Slp: Error result: 2064843076
2013-05-21 09:33:37 Slp: Result facility code: 787
2013-05-21 09:33:37 Slp: Result error code: 324

The KB2630455! build was the CTP version of SP2!?

Anyone has this issue and resolved it.

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2013-05-23 : 05:06:52

Did you run Upgrade advisory before upgrade?

mohammad.javeed.ahmed@gmail.com

james_wells
Yak Posting Veteran

55 Posts

Posted - 2013-05-24 : 11:59:38

Solved my issue

The error ocurred during the open file check , flashed up the open files window then closed with the unrecognised service name message for a service which did infact exist.

Closed down the SQL services and then the upgrade passed the open filecheck without bombing out and then upgraded the sql components includeing the report services successfully.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources