Goraps
asked on
Upgrading SQL 2005 Express to 2008 R2 Express
ASKER
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:\939d1a77ec674ea36fffa55 9\x64\setu p\
Installation edition: EXPRESS
Slipstream: True
SP Level 2
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE:
CUSOURCE:
ENU: True
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSH IP: 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: e:\939d1a77ec674ea36fffa55 9\PCUSOURC E
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAM E: Unknown
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: True
UIMODE: AutoAdvance
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20161007_213 430\Config urationFil e.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_213 430\System Configurat ionCheck_R eport.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.Chaine r.Infrastr ucture.Can celExcepti on
Message:
User has cancelled.
Stack:
at Microsoft.SqlServer.Config uration.UI Extension. Request.Wa it()
at Microsoft.SqlServer.Config uration.UI Extension. UserInterf aceProxy.N avigateToW aypoint(St ring moniker)
at Microsoft.SqlServer.Config uration.UI Extension. WaypointAc tion.Execu teAction(S tring actionId)
at Microsoft.SqlServer.Chaine r.Infrastr ucture.Act ion.Execut e(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup. Chainer.Wo rkflow.Act ionInvocat ion.Execut eActionHel per(TextWr iter statusStream, ISequencedAction actionToRun)
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:\939d1a77ec674ea36fffa55
Installation edition: EXPRESS
Slipstream: True
SP Level 2
User Input Settings:
ACTION: Upgrade
AGTDOMAINGROUP: <empty>
BROWSERSVCSTARTUPTYPE: Disabled
CONFIGURATIONFILE:
CUSOURCE:
ENU: True
ERRORREPORTING: False
FAILOVERCLUSTERROLLOWNERSH
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:\939d1a77ec674ea36fffa55
PID: *****
QUIET: False
QUIETSIMPLE: False
RSCATALOGSERVERINSTANCENAM
RSUPGRADEDATABASEACCOUNT:
RSUPGRADEPASSWORD: *****
SQLDOMAINGROUP: <empty>
SQMREPORTING: True
UIMODE: AutoAdvance
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20161007_213
Detailed results:
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20161007_213
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.Chaine
Message:
User has cancelled.
Stack:
at Microsoft.SqlServer.Config
at Microsoft.SqlServer.Config
at Microsoft.SqlServer.Config
at Microsoft.SqlServer.Chaine
at Microsoft.SqlServer.Setup.
ASKER
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
https://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx
you may need to backup DBs (detach -attach)
and unistall sql 2005 Express
How to manually uninstall an instance of SQL Server 2005
https://support.microsoft.com/en-us/kb/909967
see if your sql 2005 is 32 bit -- run select @@version
try to run Sql 2008r2 upgrade adviser
https://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx
you may need to backup DBs (detach -attach)
and unistall sql 2005 Express
How to manually uninstall an instance of SQL Server 2005
https://support.microsoft.com/en-us/kb/909967
start- programs- sql 2008 - SSMS-- run select @@version
see if version 10 -it is 20082
9.0..2005
see if version 10 -it is 20082
9.0..2005
ASKER
Sorry for my ignorance - Where / how do I run the "run select @@version"
Thanks
Thanks
check windows services
see if you got sql 2008r2 sql server service ( can have $named instance)
see if you got sql 2008r2 sql server service ( can have $named instance)
sql server management studio SSMS
https://www.microsoft.com/en-us/download/details.aspx?id=30438
Install SQL Management Studio 2008 R2 Express
https://www.youtube.com/watch?v=2xxa7fSBSD0
just in case Tutorial: SQL Server Management Studio https://msdn.microsoft.com/en-us/library/bb934498.aspx
https://www.microsoft.com/en-us/download/details.aspx?id=30438
Install SQL Management Studio 2008 R2 Express
https://www.youtube.com/watch?v=2xxa7fSBSD0
just in case Tutorial: SQL Server Management Studio https://msdn.microsoft.com/en-us/library/bb934498.aspx
ASKER
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
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
9.0
you are still connected sql 2005
try -> connect - see if you have another local sql server instance (2008R2)
check windows services to find name
you are still connected sql 2005
try -> connect - see if you have another local sql server instance (2008R2)
check windows services to find name
good
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
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
basically you need a fresh sql server and move the Orion solarwinds DB there
Prepare to upgrade or migrate SolarWinds Orion database
http://www.solarwinds.com/documentation/en/flarehelp/sam/content/core-upgrading-your-database-sw2261.htm
Prepare to upgrade or migrate SolarWinds Orion database
http://www.solarwinds.com/documentation/en/flarehelp/sam/content/core-upgrading-your-database-sw2261.htm
ASKER
good
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
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
just in case
Version and Edition Upgrades path
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
Version and Edition Upgrades path
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx
ASKER
I am having troubles with this command... How do I run it???
run Select @@version - Command prompt???
run Select @@version - Command prompt???
SSMS->connect to right sql -> new query->
select @@version -> F5 run
select @@version -> F5 run
ASKER
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)
ASKER
32 bit.... I was trying to upgrade using the x64 bit install file.
cool, now you know what to do. let us know if you still need assistance
ASKER
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)".
"failed with error message "Security Group SID(Security Identifier)".
ASKER
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$SER VERNAME$Ar cserve_DB Or SQLServer2005MSSQLUser$FRA NK$MICROSO FT##SSEE”
2) Install PStools on the backup server and run the command “psgetsid GroupName” Example: psgetsid SQLServer2005MSSQLUser$use rname$MICR OSOFT##SSE E which would return the SID value.
3) Go to HKEY_LOCAL_MACHINE\SOFTWAR E\Microsof t\Microsof t SQL Server\MSSQL1\Setup\SQLSer ver2005MSF TEUser$SER VERNAME$Ar cserve\Sel ect 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\SOFTWAR E\Microsof t\Microsof t SQL Server\MSSQL1\Setup\
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$SER
2) Install PStools on the backup server and run the command “psgetsid GroupName” Example: psgetsid SQLServer2005MSSQLUser$use
3) Go to HKEY_LOCAL_MACHINE\SOFTWAR
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\SOFTWAR
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.
ASKER
@vitor - How do I do that?
thanks
thanks
ASKER
PS: Ideally I wanted to upgrade because if I migrate I will have to re-install Primafact @ the desktop level for all my users.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Primafact is a paperless office solution mostly used in the legal industry.
ASKER
How would I know which method is best?
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 :)
How to troubleshoot a failed upgrade to SQL Server 2008
https://support.microsoft.com/en-us/kb/955399