How to Enable SQL Server when the “evaluation period has expired”

  • Anasayfa » How to Enable SQL Server when the “evaluation period has expired”

Evaluation edition of SQL Server is free for 180 days and it is equivalent to SQL Server Enterprise Version.

NOTE: I will show you how to upgrade SQL Server 2014 Evaluation edition to Enterprise. But all editions steps are the same. Just you should change product key which education you will use. (Standard, Developer, Enterpsie Edition )

NOTE: Also, if you have always on cluster servers, you should theese setps to both servers. Then, servers will work clearly.

As you can see, after completing the 180-day trial, when we try to start our SSMS, we get the following error.

When we check Windows Event view, we see that Event Id: 17051 for SQL Server has received the error “SQL Server evaluation has expired”.

Let’s check the version of SQL Server, it clearly says that we have installed the SQL Server evaluation version on this database server. In SQL Server Configuration Manager, you can import the SQL Server service by starting the property window. You can see this in the screenshot below

Now we need to upgrade SQL Server evaluation edition to bring it online and make it work as before.

To perform the upgrade, we need the SQL Server installation files. To enable your expired SQL Server evaluation version to standard, enterprise, or developer Edition, follow these steps.

Upgrade SQL Server Evaluation Edition to Enterprise Edition

  1. Let’s run our installation file as “Run As Administrator”.

2. From the installation wizard, access the Maintenance area and click Edition Upgrade option link.

3. After clicking version upgrade, the following image will appear to continue. This screen will come to enter the product key of SQL Server. Verify the correct product key and click Next to continue. Here, you must enter the key to which version you want to upgrade your SQL Server. I entered the Enterprise key
4. Let’s confirm the Linsans contract and click Next.
5. The essential controls are made, after they are all Passed, they will switch directly to the other screen.
6. On this screen, we see a list of instances installed on the server. Verify the instance of SQL Server and click Next to continue.
7. Rules will be checked by the setup and you can see the progress bar in below image.,
8. If you have done everything correctly, you can start the upgrade process by click “Upgrade”.
9. We see that the Upgrade process has been successfully completed. SQL Server Evoulation has been upgraded from a trial version to an Enterprise Edition version.
You can control the upgraded version by starting the SQL Server Service property window in the SQL Server Configuration window. Now we can see that the Edition is shown as an Enterprise Edition.

Here, we upgraded the evaluation version of SQL Server to the Enterprise version of SQL Server 2014.
Now we can start our SQL Server Service (mine is ALWAYSON1) from services

Yes, as you can see, we were able to successfully started our SQL Service in the “Running” situation.

As you can see, we have been able to connect successfully
Yes, we have come to the end of another post, hope to see you in other posts, stay healthy:))

Bir cevap yazın

Kişisel Web sayfama hoş geldiniz..