Upgrading SQL Server Standard 2012 from SP1 to SP2 fails

Hi there Experts,

To make the long story short.

I had an evaluation installation of SQL 2012 Enterprise SP1.

 I purchased an Open License version of SQL 2012 Standard SP2 Server and tried to convert
the evaluation version to retail version. After passing various checks I came across with the
following warning “The selected edition downgrade path is not valid”.

I decided to stop the conversion and upgrade first the SQL to SP2 (assuming that the warning will disappear)
After passing all checks with success and during installation of SP2 I received the attached error pushing me
to cancel the installation.

I then decided to bypass the first warring and convert to Retail Version although the SQL Evaluation Server
was running SP1.
The downgrade procedure went fine with no errors and I confirmed (via Select @@version query) that the
SQL was now converted to Standard SP1 (11.0.3128.0)
Following I tried to perform again the installation of SP2 which failed with the same attached errors.
I also tried to perform a repair setup with no luck.

Currently the SQL Server is running fine under SP1…
How could I bypass the errors and complete the upgrade to SP2??

 
Thank you for your help,


SQL SP2 Upgrade Error.png
mamelasAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you chose the "Edition Upgrade" option during the setup?
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
not sure how did you downgrade Enterprise edition to standard (please post details)
So far the only way was to uninstall  Enterprise edition  and install Standard edition:
as I can see from above post: you must resolve the error" The User Data Directory in the registry is not valid...":

You may reinstall sql server after all: please make sure to do appropriate sql server DBs backups

About the SP errors:
please review the error details and try to fix them (looks like your registry for sql server was corrupted)

---
mamelasAuthor Commented:
Dear experts,

 Thank you for your prompt replies.

I have followed the steps provided on this site in order to convert the Enterprise Evaluation to Standard Edition.

I would like to avoid reinstalling the SQL Server.Thus I tried to make a repair installation but the SP2 still fails to be installed.

Currently the SQL Server has successfully converted to Standard edition but is on SP1. When I try to install SP2 and although that all validation checks are passed the installation fails with the above attached screenshot.

Any Ideas??
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
as per this link ( SQL Server 2012 RTM Evaluation Edition _ I read "Real Enterprise downgrade"): ". As the Evaluation edition is a 180-day trial edition of Enterprise edition, there can be some issues when changing the edition to a non-Enterprise edition due to incompatible features used. "
it means you must on your own risk adjust Reg values to
address errors; 1 by 1 starting with this  " The User Data Directory in the registry is not valid...":'
check the master (system DBs, etc) location and adjust to this path:
(do registry keys backup)

see solution from:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c9babbfd-0289-451f-af35-9f3937c3d13e/error-upgrading-sql-2012-sp1-to-sp2?forum=sqlsetupandupgrade


and this one (similar):

SQL Server 2012 SP1 Installation issue
https://connect.microsoft.com/SQLServer/feedback/details/778275/sql-server-2012-sp1-installation-issue
"Resolved by editing the registry value for HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL11.<MyInstance>\Setup\SQLDataRoot - to update it to the current location of the system databases. (This value was still set to the original folder from the install)."

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mamelasAuthor Commented:
Dear Experts,

Apologies for my late reply but I was out-of-office.

I will check the above recommendations and I will revert.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.