SQL Server evaluation period has expired:Unable to start SQL services

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.


Scenario:-

It doesn’t happen so often as company always use the licensed SQL server but sometime on Development or Lab environment people use the evaluation edition of SQL server to explore its features that come along this it.

Features of evaluation edition are same as enterprise edition but it has 180 days trail period. Post 180 days services get stuck/stop and you can not bring them UP and you will see the logs in event viewer as below:-

Event Viewer Log.
You may see this error pop-up while attempting SQL services up from services.msc

What does this mean? You will need to license it or if this happens at home while doing some R&D you can change the date of system with some past date and try to bring the services UP.

In this tutorial, we will talk about upgrading the edition SQL 2016 from evaluation to SQL 2016 Enterprise (you can anyway upgrade to standard as well). All we need to know the steps to be followed and yeah most important License keys.

 

Note:- Please keep in mind while upgrading to standard edition from evaluation edition as evaluation edition comes with Enterprise features (highest features) and you may not see some of the features in standard edition.


 

Solution:

InterServer Web Hosting and VPS

 

  • Open the SQL server installation center (search the name in the search box of your system)
  • Go to Maintenance tab and click on Edition Upgrade.
Now enter the license Key here.
  • Now accept the license terms.
  • Select the Instance to upgrade from the list.
  • Click next, review the upgrade and Click Upgrade button.

Hope this helps!

 

 

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s