Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Upgrading from 2005 to 2008, setup does not detect existing installation

Beantwortet Upgrading from 2005 to 2008, setup does not detect existing installation

  • Thursday, October 04, 2012 9:32 PM
     
     
    Sign In to Vote
    0

    I've got an x64 Standard install of 2005, I'm trying to upgrade to x64 Standard 2008. When I run the upgrade I get the error "There are no features selected for upgrade". When I look at the log, it seems that the existing installation is not being detected:

    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-10-04 16:19:18
      End time:                      2012-10-04 16:21:58
      Requested action:              Upgrade

    Machine Properties:
      Machine name:                  COMPUTER1
      Machine processor count:       2
      OS version:                    Windows Server 2008
      OS service pack:               Service Pack 1
      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

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         D:\x64\setup\
      Installation edition:          STANDARD

    User Input Settings:
      ACTION:                        Upgrade
      AGTDOMAINGROUP:                <empty>
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:            
      ERRORREPORTING:                False
      FAILOVERCLUSTERROLLOWNERSHIP:  2
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      FTUPGRADEOPTION:               Import
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      MEDIASOURCE:                   D:\
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      RSCATALOGSERVERINSTANCENAME:   Unknown
      RSUPGRADEDATABASEACCOUNT:     
      RSUPGRADEPASSWORD:             *****
      SQLDOMAINGROUP:                <empty>
      SQMREPORTING:                  False
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121004_161622\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\20121004_161622\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.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

    I have no idea why this is happening, can anyone shed some light on this? The version of 2005 is 9.00.4053.00, which I believe is SP3.

     

All Replies

  • Thursday, October 04, 2012 9:41 PM
    Moderator
     
     
    Sign In to Vote
    0

    Can you share discovery report, to generate discovery report check-out

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

     
  • Thursday, October 04, 2012 9:51 PM
     
     
    Sign In to Vote
    0

    It shows the exact same thing, which is nothing, basically:

    Microsoft
    SQL Server 2008 Setup Discovery Report

    Product Instance Instance ID Feature Language Edition Version Clustered
    None None None None None None None None
     
  • Thursday, October 04, 2012 10:37 PM
     
     
    Sign In to Vote
    0
    The SQL Server Configuration Manager doesn't list anything either.
     
  • Thursday, October 04, 2012 10:41 PM
     
     
    Sign In to Vote
    0

    Hi,

    Not being able to view the services via SSCM is the root cause here. Can you review this KB and check your permissions for the network service as per this KB?

    http://support.microsoft.com/kb/941823

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

     
  • Thursday, October 04, 2012 10:55 PM
    Moderator
     
     
    Sign In to Vote
    0

    one thing else can you upload all log folders under

     C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

    you can use file sharing/storage service  like SkyDrive.com to  share the log folders

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

     
  • Friday, October 05, 2012 4:29 PM
     
     
    Sign In to Vote
    0
    Ok, I've done this and verified it's in place by setting a service to Disabled then rebooting and the service comes back up as Automatic by way of the GP. However, there is still nothing in SSCM.
     
  • Saturday, October 06, 2012 5:43 AM
     
     Answered
    Sign In to Vote
    0
    You may have to contact Microsoft Support but I would be considering a re-install of 2005. It looks like the underlying permissions have been messed up and I would have concerns about trying to upgrade on this hardware. I might event consider installing 2008 side by side with 2005 then migrate the databases to the 2008 instance.

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    • Marked As Answer by Aubrey Tuesday, October 09, 2012 2:47 PM
    •