SQL Server evaluation period has expired after upgrade

Extend SQL Server Evaluation Period

In the previous post, we have explained How to extend SQL Server evaluation period. In this post, we’ll solve SQL Server evaluation period has expired after upgrade and how to use SQL Management Studio after SQL Server evaluation period has expired by exploring the following:

[toc]

SQL Server Trial period has expired

You may also like to read Windows Server Evaluation Period has expired, How to extend it?


SQL Server Evaluation Period has expired after upgrade

As we earlier mentioned, you can extend the SQL Server Trial period for additional days (~30 days).

But, If SQL Server evaluation period has expired after upgrade, you will not be able to extend it again.

In this section, we’ll answer the below related questions:

  • What happened when SQL Server evaluation period has expired after upgrade?
  • SQL Server evaluation period has expired after upgrade, how to extend it?

You may also like to check Supported SQL Server Versions for SharePoint 2016

What happened when SQL Server evaluation period has expired after upgrade?

When SQL Server evaluation period has expired after upgrade, if you tried to open SQL Server Management Studio, you will face the below error message:

SQL Evaluation Period has expired 

SQL Server Evaluation period has expired

Also, if you opened the “SQL Server Configuration Manager”, you will note that all SQL Server Services stopped as shown below.

Extend SQL Server Trial Period again

Moreover, if you tried to restart SQL Server Services, you will get the below error message.

The request failed or the service did not respond in a timely fashion

The request failed or the service did not respond in a timely fashion

SQL Server Evaluation Period has expired after upgrade, how to extend it?

As we earlier mentioned, If you have already extended SQL Server Evaluation period, and the SQL Server evaluation period has expired after upgrade, you will not be able to extend it again!

In this case, you only have the below suggestions:

  • Purchase a new SQL Server license.
  • Build a new SQL Server Trial environment.
  • Downgrade your SQL Server enterprise edition to SQL Server free express edition.

Besides the above-mentioned suggestions, you can also go through the below unpractical workaround to be able to use SQL Server Management Studio after the SQL Server evaluation period expired after upgrade.

Note: Extending SQL server evaluation period is not supported for the production environment. it should be only used for a development environment.

Extend SQL Server Evaluation Period after upgrade

Steps
  • Just change the machine date to a specific date when the SQL server was worked properly.
  • Click on “Change date and time settings”.
change date time | Extend SQL Server Evaluation period that already extended
  • In the “Date and Time Setting”, Set the machine date to an old date as shown below.
change to date that it working before | Extend SQL Server Evaluation period that already extended
  • Open SQL Server Configuration Manager as Administrator.
Open SQL Server Configuration
  • From the right side, click on “SQL Server Service”You will note that all SQL Services stopped!
Extend the SQL Evaluation period after the second expiration
  • Restart the SQL Server Services.SQL Server Instance.
    • SQL Server Agent.
    • SQL Server Browser.
    • SQL Server Reporting Service (if it’s already installed).
Start SQL Server Services - Extend the SQL Evaluation period after the second expiration
  • The services should be started properly.
ReStart SQL Server Services - Extend the SQL Evaluation period after the second expiration
  • Go back to open SQL Server Management Studio,
  • It should be working properly without showing the expiration message.
Open SQL - Extend the SQL Evaluation period after the second expiration
  • Connect to your SQL Server instance to make sure that the SQL server is working properly.
Connect to SSMS
  • Finally, adjust the server date to be today to avoid any related time on your SQL Server.
SQL Server evaluation period has expired after upgrade

Important Note: the above steps are a temporary workaround that should be applied each time you open SQL Management Studio to avoid showing the expiration message and can connect to your instance.


Applies To
  • SQL Server 2012.
  • SQL Server 2014.
  • SQL Server 2016.
  • SQL Server 2017.
  • SQL Server 2019.

Update: Due to the SQL Server Management Studio is now a free separated product, you can download and use it for previous and latest SQL Server versions without getting this expiration message.

Conclusion

In conclusion, we have introduced a trick to open SQL management studio if the SQL Server evaluation period has expired after upgrade.

You may also like to read
Have a Question?

If you have any related questions, please don’t hesitate to Ask it at deBUG.to Community.

5 thoughts on “SQL Server evaluation period has expired after upgrade”

  1. Pingback: Extend SQL Server Evaluation Period | SPGeeks

Leave a Reply