SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 error upgrading to sql2008r2 sp2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

james_wells
Yak Posting Veteran

53 Posts

Posted - 05/21/2013 :  05:27:44  Show Profile  Reply with Quote

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

India
573 Posts

Posted - 05/23/2013 :  05:06:52  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Did you run Upgrade advisory before upgrade?

mohammad.javeed.ahmed@gmail.com
Go to Top of Page

james_wells
Yak Posting Veteran

53 Posts

Posted - 05/24/2013 :  11:59:38  Show Profile  Reply with Quote
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.





Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000