cancel
Showing results for 
Search instead for 
Did you mean: 

DB upgrade from 2005 to 2008

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

former_member184473
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

former_member184473
Active Contributor
0 Kudos

Hello Mag,

In the summary we can see:

Final result:                  User cancelled

Did you try to upgrade the system more than one time?

Also, did you try the following steps?

  1. Uninstall the SQL Server
  2. Performance a fresh installation directly on SQL Server 2008 R2
  3. Restore the database backup

Regards,

Eduardo

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.