on 04-23-2012 3:45 PM
Hi,
We are upgrading our SQL Server database 2005 Sp2 to 2008 R2.
During the process of upgrade we are facing issues, "SQL Server 2008
R2 has completed with failures"
Detail: LOG
2012-04-21 23:11:09 Slp: Error result: -2068119551
2012-04-21 23:11:09 Slp: Result facility code: 1211
2012-04-21 23:11:09 Slp: Result error code: 1
2012-04-21 23:11:09 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey
2012-04-21 23:11:09 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2012-04-21 23:11:09 Slp: Sco: Attempting to get registry value DW0201
2012-04-21 23:12:04 Slp: Submitted 1 of 1 failures to the Watson data repository
Please suggest.
Regards,
Mag
HI,
I havent run STM tools yet and also in services.msc i can see that SQL DB services has started and is running with 10.5 version. but agent is still with 9,0 version and unable to start it.
Please suggest .
Regards,
Mag.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mag,
Have you checked the summary.log for further information?
If you have a full database backup you may try to uninstall the SQL Server, install the SQL Server software and restore the database backup:
http://support.microsoft.com/kb/955404/en
Regards,
Eduardo Rezende
HI Eduard,
Thank you for responding for my query.
Summary Log:
Overall summary:
Final result: User cancelled
Exit code (Decimal): -2068380094
Exit facility code: 1207
Exit error code: 1602
Exit message: User has cancelled.
Start time: 2012-04-22 00:32:42
End time: 2012-04-22 00:38:00
Requested action: Upgrade
Machine Properties:
Machine name: MGTLDVLP
Machine processor count: 2
OS version: Windows Server 2008 R2
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 Tools 1033 Enterprise Edition (64-bit) 9.2.3042 No
Sql Server 2005 ToolsClient 1033 Enterprise Edition (64-bit) 9.2.3042 No
Sql Server 2005 ToolsClient\Connectivity 1033 Enterprise Edition (64-bit) 9.2.3042 No
Sql Server 2005 ToolsDocument 1033 Enterprise Edition (64-bit) 9.2.3042 No
Sql Server 2005 ToolsDocument\BOL 1033 Enterprise Edition (64-bit) 9.2.3042 No
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text Search 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 Management Tools - Basic 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 Management Tools - Complete 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 Client Tools Connectivity 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 Client Tools Backwards Compatibility 1033 Enterprise Edition 10.51.2769.0 No
Sql Server 2008 R2 Client Tools SDK 1033 Enterprise Edition 10.51.2769.0 No
Package properties:
Description: SQL Server Database Services 2008 R2
ProductName: SQL Server 2008 R2
Type: RTM
Version: 10
Installation location: D:\SQL\MSSQLSERVER2008R2\51041678\x86-x64-IA64\EnterpriseEdition\x64\setup\
Installation edition: ENTERPRISE
Slipstream: True
SP Level 1
Patch Level: 10.51.2769.0
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE:
CUSOURCE: D:\SQL\MSSQLSERVER2008R2\51041678\x86-x64-IA64\EnterpriseEdition\CU
ENU: True
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSHIP: 2
FARMACCOUNT: <empty>
FARMADMINPORT: 0
FARMPASSWORD: *****
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
FTUPGRADEOPTION: Import
HELP: False
INDICATEPROGRESS: False
INSTANCEID: <empty>
INSTANCENAME: <empty>
ISSVCACCOUNT: NT AUTHORITY\NetworkService
ISSVCPASSWORD: *****
ISSVCSTARTUPTYPE: Automatic
PASSPHRASE: *****
PCUSOURCE: D:\SQL\MSSQLSERVER2008R2\51041678\x86-x64-IA64\EnterpriseEdition\PCU
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAME: Unknown
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: False
UIMODE: Normal
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120422_003149\ConfigurationFile.ini
Detailed results:
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120422_003149\SystemConfigurationCheck_Report.htm
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
Message:
User has cancelled.
Stack:
at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.NavigateToWaypoint(String moniker)
at Microsoft.SqlServer.Configuration.UIExtension.WaypointAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
Please sugges
Regards,
Mag.
HI Eduardo,
I did tried to upgrade it using sidadm multiple times but it did not through it stopped at setp 3 "Select features"
2) As i am upgrading 2005 to 2008 R2, is there by any means i can revert back to SQL 2005
3) In the services.msc i can see that MS SQL service has been update to 10.5 but agent is still on 9.0
Please suggest.
Regards,
Mag.
HI Eduardo,
Initially we tried to install using "Administrator" but installation completed with errors, Later tried with SID adm users multiple times but it stopped at Step3: "Select features"
1) Is there any way i can Uninstall 2008 db and revert back to 2005 and then reinstall the upgrade activity of SQL Server 2008
Please suggest
Regards,
Mag.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.