Upgrade SQL Server 2012 from Eval to Licensed (downgrade warning?)

We need to convert our 180-day eval of SQL Server 2012 to Open License version. When we go through process and enter the product key - we come to this point and not sure what it means and whether we go forward. Also not sure if we need to get everyone OFF the server before converting to licensed product. Here is the warning we get ...

SQL Server 2012 edition downgrade    WARNING
We click WARNING link and get this ...  "Rule 'SQL Server 2012 edition downgrade' generated a warning. The selected edition downgrade path is not valid."
interc3905Asked:
Who is Participating?
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.

David Johnson, CD, MVPOwnerCommented:
What version of the eval ?  It would appear that only uninstalling and reinstalling is your option
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think you can't upgrade an eval edition. Eval edition should be used only as a trial and not as definitive solution. For that you'll need to install an appropriate edition.
0
interc3905Author Commented:
Wrong about evaluation not being able to upgrade to permanent license. I will send details to follow and ACCEPT what I found is the solution. FYI - Microsoft insisted that I uninstall and re-install and I told them that is unacceptable considering the server is in production for 180 days now and working at a 911 center. Doing a little research I found the solution.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

interc3905Author Commented:
Instructions on how I solved the issue:
1. A 180-day evaluation of 2012 SQL Server was installed (I assume it comes with ALL features)
2. To upgrade to permanent license run the same SETUP.EXE used to install eval
3. Click on Maintenance link on left side menu
4. Click Edition Upgrade link and then OK on window that comes up
5. Click NEXT and then select ENTER THE PRODUCT KEY
6. We ordered a Open License 2014 SQL Server from Microsoft when had to download the 2012 SQL Server Standard from the volume license website (which by the way states NO license is required for this product). Microsoft stated that the license was embedded in the software and claimed we would have to uninstall and re-installed with the new ISO download.
7. Download the ISO and unzip with 7zip
8. In my case the extracted path looks like this (go to the x64 directory): C:\Users\Administrator\Downloads\SW_DVD9_SQL_Svr_Standard_Edtn_2012w_SP2_64Bit_English_-2_MLF_X19-75010\x64
9. Open the DefaultSetup.ini file to grab the Product Key
10. Go back to Step 5 and enter that KEY and click NEXT
11. Check to ACCEPT license terms and NEXT
12. It will check the RULES and in our case we got one WARNING for SQL Server 2012 edition downgrade (turns out that Eval installed all features which we did not need)
13. Click NEXT and it took about 2 minutes to do upgrade
14. Repeat process to see if the license took and now says Standard instead of Evaluation (go all the way to step 11 to see if Standard is now there). Cancel so you don't repeat.

Now I need to stress that the Eval did not expire YET so in that case you may have to uninstall and re-install but then again maybe not.
0

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
DcpKingCommented:
From your posted solution you indicate that you are licencing Standard Edition ("SW_DVD9_SQL_Svr_Standard_Edtn_2012w_SP2_64Bit_English_-2_MLF_X19-75010"),
I believe that you will find that the 120-day Evaluation is of a copy of Enterprise Edition - hence your receipt of a warning that you were attempting to downgrade your install: "SQL Server 2012 edition downgrade    WARNING"

I would also guess that you had installed functionality in the Eval that would not be available in Standard Edition, hance the refusal to install (your step 12). For an account with pictures see here.

I would like to suggest that you look very carefully at what you are using before switching from the Eval version to Standard edition - Standard Edition may very well support all you need, but if your developers have used features unavailable in STandard Edition you may encounter sudden failures. As an example, there is a feature in SSRS that lets you define conditions in the database that, when met, will trigger the sending out of a report - "data-driven subscriptions". These are not available in Standard Edition, and you may not realise that some client is expecting them until the client realises that they are missing and complains.

Good luck (sorry I didn't see the question earlier: I am not looking for points.)

Mike
0
interc3905Author Commented:
No one solved my problem.
0
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.

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.