November 26, 2014 at 12:24 pm
Okay so let me start by saying that I have an environment that is SQL Server 2005 SP4 and we are attempting to upgrade to 2012. During our first run of the upgrade we had an issue where the install/upgrade failed due to a missing windows service pack (yea I know bad DBA); this was resolved.
The next/current issue is that we keep getting all the way to the end of the upgrade and the upgrade fails with the following message: Specified instance {C22864D5-FB3F-4609-BF0C-ADBCC70742C4} via transform :InstID02.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
When I review the report at the end of the upgrade it basically says that it failed on the Full Text Search component. Currently we are not actively using full text search in our DB. During the install we chose the option to "Reset" on the Full Text Search Page (not sure if this is an issue or not).
Things we've done:
- Cleared the Orphaned Registry Hives prior to reattempting upgrade
- Performed command line uninstall prior to remove all components
- Rebooted after above items....
Following is the log file output; any help on resolving this issue would be great.
=== Verbose logging started: 11/26/2014 0:31:49 Build type: SHIP UNICODE 5.00.7601.00 Calling process: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012\x64\ScenarioEngine.exe ===
MSI (c) (00:F8) [00:31:49:797]: Resetting cached policy values
MSI (c) (00:F8) [00:31:49:797]: Machine policy value 'Debug' is 0
MSI (c) (00:F8) [00:31:49:797]: ******* RunEngine:
******* Product: L:\SW_DVD9_SQL_Svr_Ent_Core_2012_English_MLF_X17-99682\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msi
******* Action:
******* CommandLine: **********
MSI (c) (00:F8) [00:31:49:799]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (00:F8) [00:31:49:799]: Grabbed execution mutex.
MSI (c) (00:F8) [00:31:49:801]: Cloaking enabled.
MSI (c) (00:F8) [00:31:49:801]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (00:F8) [00:31:49:802]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (DC:80) [00:31:49:808]: Running installation inside multi-package transaction L:\SW_DVD9_SQL_Svr_Ent_Core_2012_English_MLF_X17-99682\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msi
MSI (s) (DC:80) [00:31:49:808]: Grabbed execution mutex.
MSI (s) (DC:D4) [00:31:49:809]: Resetting cached policy values
MSI (s) (DC:D4) [00:31:49:809]: Machine policy value 'Debug' is 0
MSI (s) (DC:D4) [00:31:49:809]: ******* RunEngine:
******* Product: L:\SW_DVD9_SQL_Svr_Ent_Core_2012_English_MLF_X17-99682\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\sql_engine_core_inst_loc.msi
******* Action:
******* CommandLine: **********
MSI (s) (DC:D4) [00:31:49:810]: Machine policy value 'TransformsSecure' is 1
MSI (s) (DC:D4) [00:31:49:932]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (DC:D4) [00:31:49:932]: Specified instance {C22864D5-FB3F-4609-BF0C-ADBCC70742C4} via transform :InstID02.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (DC:D4) [00:31:49:933]: MainEngineThread is returning 1639
MSI (s) (DC:80) [00:31:49:934]: User policy value 'DisableRollback' is 0
MSI (s) (DC:80) [00:31:49:934]: Machine policy value 'DisableRollback' is 0
MSI (s) (DC:80) [00:31:49:934]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (DC:80) [00:31:49:934]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (DC:80) [00:31:49:935]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (DC:80) [00:31:49:935]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (DC:80) [00:31:49:935]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (DC:80) [00:31:49:935]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (DC:80) [00:31:49:935]: Restoring environment variables
MSI (c) (00:F8) [00:31:49:938]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:F8) [00:31:49:938]: MainEngineThread is returning 1639
=== Verbose logging stopped: 11/26/2014 0:31:49 ===
November 26, 2014 at 3:24 pm
what OS is the server at?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 12:14 am
OS: Windows 2008 R2
November 27, 2014 at 3:24 am
which edition of SQL Server 2005 and 2012 are you upgrading between
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2014 at 10:13 pm
2005 SP4 Standard to 2012 Enterprise
December 3, 2014 at 4:38 pm
So thanks for the responses; it turns out that there was an additional orphaned node in the Registry for Analysis Services that needed to be cleaned out as well. Once that was done the upgrade process ran through without any issue.
Thanks again.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply