Upgrading SQL 2005 Express to 2008 R2 Express

I get the following error when trying to upgrade SQL 2005 to 2008R2 express.   2005 SQL Express is currently running on a Windows 2008 R2 server which is also a DC.

GorapsI.T. ManagerAsked:
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
How do I do that?
You can follow one of mine articles:
SQL Server database migration - The Detach/Attach method
SQL Server database migration - The Backup & Restore method
SQL Server database migration - The Copy Database Wizard method

if I migrate I will have to re-install Primafact @ the desktop level for all my users.
Why is that? I would expect that only think you'll need is to update the connection string with the new SQL Server instance name.
Eugene ZCommented:
follow MS support article resolution "There are no features selected for upgrade"

How to troubleshoot a failed upgrade to SQL Server 2008
GorapsI.T. ManagerAuthor Commented:
there is nothing in the log file stating what should be done to fix the issue.

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:                    2016-10-07 21:35:12
  End time:                      2016-10-07 21:37:18
  Requested action:              Upgrade

Machine Properties:
  Machine name:                  MY_SERVER
  Machine processor count:       16
  OS version:                    Windows Server 2008 R2
  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
  Sql Server 2005      SOLARWINDS_ORION     MSSQL.1                        Database Engine Services                 1033                 Express Edition      9.3.4035        No        
  Sql Server 2005      SOLARWINDS_ORION     MSSQL.1                        SharedTools                              1033                 Express Edition      9.3.4035        No        
  Sql Server 2005                                                          Tools                                    1033                 Express Edition      9.3.4035        No        
  Sql Server 2005                                                          ToolsClient                              1033                 Express Edition      9.3.4035        No        
  Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Express Edition      9.3.4035        No        
  Sql Server 2008 R2   EMERGENT             MSSQL10_50.EMERGENT            Database Engine Services                 1033                 Express Edition      10.52.4000.0    No        
  Sql Server 2008 R2   EMERGENT             MSSQL10_50.EMERGENT            SQL Server Replication                   1033                 Express Edition      10.52.4000.0    No        
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Express Edition      10.52.4000.0    No        

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  Installation location:         e:\939d1a77ec674ea36fffa559\x64\setup\
  Installation edition:          EXPRESS

  Slipstream:                    True
  SP Level                       2

User Input Settings:
  ACTION:                        Upgrade
  AGTDOMAINGROUP:                <empty>
  ENU:                           True
  ERRORREPORTING:                False
  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:                     e:\939d1a77ec674ea36fffa559\PCUSOURCE
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  RSUPGRADEPASSWORD:             *****
  SQLDOMAINGROUP:                <empty>
  SQMREPORTING:                  True
  UIMODE:                        AutoAdvance
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20161007_213430\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\20161007_213430\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
        User has cancelled.
        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)
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

GorapsI.T. ManagerAuthor Commented:
I also notice that it says that 2008 is already installed:  How can I tell what version of SQL is opening up the current DB's?

Eugene ZCommented:
make sure you run upgrade "as administrator" even you are local admin

see if your sql 2005 is 32 bit -- run select @@version

try to run Sql 2008r2 upgrade adviser
you may need to backup DBs (detach -attach)
and unistall sql 2005 Express
How to manually uninstall an instance of SQL Server 2005
Eugene ZCommented:
start- programs- sql 2008 - SSMS-- run select @@version
see if version 10 -it is 20082
GorapsI.T. ManagerAuthor Commented:
Sorry for my ignorance - Where / how do I run the  "run select @@version"

Eugene ZCommented:
check windows services
see if you got sql 2008r2 sql server service ( can have $named instance)
Eugene ZCommented:
sql server management studio SSMS

Install SQL Management Studio 2008 R2 Express

just in case Tutorial: SQL Server Management Studio https://msdn.microsoft.com/en-us/library/bb934498.aspx
GorapsI.T. ManagerAuthor Commented:
Under services it only shows:  SQL server - No version info.

When I open SSMS it shows the version as - 9.0.4035

Eugene ZCommented:
as per above post
you have already 2nd sql server instance 2008R2
and if it is what you need --  just review sql 2005 and plan to un-install it if you do not need it

the "manual sql 2005 uninstall" above post may help
Eugene ZCommented:
you are still connected sql 2005
try -> connect - see if you have another local sql server instance (2008R2)
check windows services to find name
GorapsI.T. ManagerAuthor Commented:
The SSMS version is Version 8 tho.

Eugene ZCommented:
in ssms-( click(left) )-> connect->database engine-> server name -> browse for more -> local servers
see if your sql 2008r pops-up

--BTW on sql 2005 run - in a new query window- -select @@version to see if it is 32 bit
Eugene ZCommented:
basically you need a fresh sql server and move the Orion solarwinds DB there
Prepare to upgrade or migrate SolarWinds Orion database
GorapsI.T. ManagerAuthor Commented:
Looks like one DB is using 2005 and one is using 2008... the one that is using 2005 is the one that I currently need using 2008.

2 DBs
Eugene ZCommented:
if you still desire to upgrade this 2005
run  Select @@version
if it is 32 bit -- you need to upgrade to 32bit

or just use the \emergent instance after migrating DB there
or install a new Orion208r2 Sql instance and un- install the old sql 2005 later
Eugene ZCommented:
just in case

Version and Edition Upgrades path
GorapsI.T. ManagerAuthor Commented:
I am having troubles with this command... How do I run it???

run  Select @@version     - Command prompt???
Eugene ZCommented:
SSMS->connect to right sql -> new query->
 select @@version   -> F5  run
GorapsI.T. ManagerAuthor Commented:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)   Nov 24 2008 13:01:59   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
GorapsI.T. ManagerAuthor Commented:
32 bit.... I was trying to upgrade using the x64 bit install file.
Eugene ZCommented:
cool, now you know what to do. let us know if you still need assistance
GorapsI.T. ManagerAuthor Commented:
So it definitely was to do with me running the x64 version of the install... Not when I get to the "UPGRADE RULES" I get another error as follows:

"failed with error message "Security Group SID(Security Identifier)".
GorapsI.T. ManagerAuthor Commented:
I've tried following the KB articles online and all of them have these same steps:

If its a Domain Controller, go to Active Directory Users and Computers and search for Sql groups and look for same above groups.

1) Go to administrative Users and groups and get the complete name of the SQL User Example: SQLServer2005MSFTEUser$SERVERNAME$Arcserve_DB Or SQLServer2005MSSQLUser$FRANK$MICROSOFT##SSEE”

2) Install  PStools on the backup server and run the command  “psgetsid GroupName”  Example: psgetsid SQLServer2005MSSQLUser$username$MICROSOFT##SSEE which would return the SID value.

3) Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL1\Setup\SQLServer2005MSFTEUser$SERVERNAME$Arcserve\Select the SID on the right side screen

4) Verify if the value of Agtgroup, FTEgroup, SQLuserGroup matches the ones returned from psgetsid. If not, replace the SID value which we got by running above psgetsid.

5) Run the SQL 2008 Upgrade again . This should fix the installation issue.

I do not have this REGEDIT entry on my server so I am unable to find the SID in question:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL1\Setup\
Vitor MontalvãoMSSQL Senior EngineerCommented:
Goraps, instead of upgrading the current MSSQL 2005 to 2008R2 why don't you migrate only the databases to the existing MSSQL 2008R2 instance? That way you can uninstall old MSSQL 2005 instance.
GorapsI.T. ManagerAuthor Commented:
@vitor - How do I do that?

GorapsI.T. ManagerAuthor Commented:
PS: Ideally I wanted to upgrade because if I migrate I will have to re-install Primafact @ the desktop level for all my users.
GorapsI.T. ManagerAuthor Commented:
Primafact is a paperless office solution mostly used in the legal industry.
GorapsI.T. ManagerAuthor Commented:
How would I know which method is best?
Vitor MontalvãoMSSQL Senior EngineerCommented:
How would I know which method is best?
If you read them you'll know ;)
But usually the 1st or the 2nd will be preferable. It's more to chose the flavor that you like it most :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.