1

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message:

pic1

I entered the activation code that is correct for SQL Server 2019 standard. I can’t understand why the reports show that Enterprise is installed if when install was the evaluation version.

pic2

How can I install and activate the Standard version of the SQL server 2019?

0

The Microsoft article Supported version & edition upgrades (SQL Server 2019) says this:

Upgrading from Evaluation (a free edition) to any of the paid editions is supported for stand-alone installations, but is not supported for clustered installations.

So what you are trying to do is feasible.

Details on the procedure can be found in the article Upgrade to a Different Edition of SQL Server (Setup).

In a nutshell, try first the "SQL Server Installation Center", click Maintenance, and then select Edition Upgrade.

If this fails, try it from setup.exe of the Standard version.

If all fails, uninstall the Enterprise evaluation version and install the Standard version.

5
  • Unfortunately this will not solve my problem, as I have an activation key for the Standard version. but my instance after installation for some reason becomes Enterprise, why? (or, if I use the activation key for Enterprise, then I can activate it.) – Red Hat Apr 29 '20 at 13:22
  • If your installation has become corrupted and does funny stuff, uninstall and reinstall should solve it. – harrymc Apr 29 '20 at 13:26
  • Or, if the installation media is bad, try to download it again (maybe for here). Is it possible you got an Enterprise serial by mistake? – harrymc Apr 29 '20 at 14:04
  • maybe the key is not correct, I wrote to the local supplier. – Red Hat Apr 29 '20 at 14:43
  • The cause of the problem was that the reseller provided the another activation key. – Red Hat May 20 '20 at 7:39
0

Check for capitalization, G=6 and other similar mis-typings. Maybe your code is invalid because it has been used by others? Call Microsoft as a next step.

3
  • The activation key is 100% entered correctly. why after installing the evaluation edition in reports it shows that enterprise is installed? – Red Hat Apr 29 '20 at 4:28
  • I don’t believe it’s possible to downgrade from Enterprise to Standard. – Ramhound Apr 29 '20 at 7:38
  • Agree. Might have to uninstall and reinstall standard. Not sure as I've never tried this before. – MicroNateId Apr 30 '20 at 14:29
0

It looks like for a downgrade from Enterprise to Standard edition you have to run the setup file. Please check your 1st screenshot and click on "Edition Upgrade".

1
  • Unfortunately this will not solve my problem, as I have an activation key for the Standard version. but my instance after installation for some reason becomes Enterprise, why? (or, if I use the activation key for Enterprise, then I can activate it.) – Red Hat Apr 29 '20 at 13:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.