Avatar of SiemensSEN
SiemensSEN
 asked on

error upgrading SQL server from 2005 -- 2012

Hello,
  I get the following error when I tried to upgrade my SQLserver . Please let me know how i can fix this issue.

=== Error 1 ==
TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

The specified local group already exists. (Exception from HRESULT: 0x80070563)

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

The directory property cannot be found in the cache.


Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xED20C17F%25400x02C5AE77

--ERROR 2 -- I selected retry after error 1

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xED20C17F%25400x02C5AE77

---------------------------------------------------------------
After pressing cancel button I see a dialog that with fail status for the database

I attach the log. Please have a look . The link provided in message does not work..

Thanks
msssql.err.txt
Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
ProjectChampion

8/22/2022 - Mon
arnold

Why not install it as a new instance (if you require it to be the default instance, an option is to add another IP to the system and bind the 2012 instance to this IP.
Once the DB is installed, you can use login transfer scripts that exist on MS and then backup/restore the DBs one application at a time, while transitioning the applications to point to the new sql 2012.

The issue will provide for a controlled transition as well as provide for a way to revert if some incompatibilities are encountered.

Presumably you used this prior to initiating the upgrade attempt.
http://technet.microsoft.com/en-us/library/ms144256.aspx

Yes, you would need to have adequate space to handle both for a time.

Once the DB/application transition is done, you can rescind the binding of sql 2012 to the single IP.
....
SiemensSEN

ASKER
Sorry but I cannot do an in-plae upgrade. Do you know what the error means or how to fix it. The link on how to resolve the issue that is displayed by the installation is not valid.

Thanks for your help
ProjectChampion

Arnold is right, if you don't want to do an in-place upgrade, then you have to install the new SQL Server as a "named instance".
The error message is telling you exactly the same; you can't have two default instances running on the same server.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
SiemensSEN

ASKER
Sorry again..

I have SqlServer 2005 install in thia machine  and I want to upgrade it . So, I am doing an in-place upgrade  and then I get the error.
I ran the upgrade advisior and it gave no error.

Thanks
ProjectChampion

Ah I see. There are a number of different reasons that may cause the error message you're getting. To further investigate go to the registry
"HKEY_LOCAL_MACHINE > Software > Microsoft > Windows > Currentversion > Run" to find which file is the error message referring to. You can then decide on the action that you need to take based on that info.
SiemensSEN

ASKER
Thanks for your help

no value  is set in registry.


I de-install using the information in the help text

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012>setup /q
 /action=uninstall /instanceid=CQ2005 /features=SQLENGINE,FULLTEXT,REPLICATION,A
S


And re-install and got this error below..

Also, Although  i remove the installation the information for SQLserver 2012 is still in add/remove dialog


TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

The directory property cannot be found in the cache.


Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xED20C17F%25400x02C5AE77

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ProjectChampion

I can't be sure without actually looking at the server but it looks like the installation process has bumped into some missing packages or modules and is trying to add them back from the original source media, which obviously may not be accessible anymore...
but you can fix it and it's not as daunting as it may sound.

First locate the directory containing FindSQLInstalls.vbs and open up an elevated command prompt to that directory and run the following command:
Cscript FindSQLInstalls.vbs %computername%_sql_install_details.txt

Then open up the text file that you've just created and search for "!!!" and "do not".
Based on the info you have to take corrective action to resolve all items found in the previous step, one issue at a time. You have to repeat the process until there are no "!!!" or "do not" in that file.
SiemensSEN

ASKER
Sorry but I could not get it to  work.  I may have remove entries from the registry that cause this issue.

So, I reinstall the server and SQL server 2005 then upgraded to 2012 .  I saw no error . However,  in windows add/remove dialog I still see an entry for "Microsoft SQL server 2005(64) with no size or version associated with it.  Is this normal? . How do I remove it.
ASKER CERTIFIED SOLUTION
ProjectChampion

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question