When SQL Server Evaluation Edition will Expire ?

Leave a comment (0) Go to comments

Evaluation Edition works for 180 days from the date of installation. Thus, it’s very import for me to know when it is going to stop working

There are three ways to get this information,

Solution 1

Open the Management Studio, click on the "Help" of Menu Bar and then on "About". In the new window you will see some thing like this:

When SQL Server Evaluation Edition will Expire ? when sql server server evaluation edition going to stop working The evaluation period has expired for this evaluation version of SQL Server sql server Event ID: 17052 SQL Server evaluation period has expired 17052 SQL Server evaluation period has expired How can I know when sql server 2005 Evaluation Edition will Expire Expiration Date of SQL Server Evaluation Edition Event ID: 17052 sql server

Note: This assumes that you installed SSMS along with Engine as part of the same install.

Solution 2

You can check the windows installer for the SQL Product code to pull out the install date
In registry look under,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\<GUID>\InstallProperties

Notes :

  • The "InstallDate" key will have the date stored in YYYYMMDD
  • For SQL 2008 you can search for "Microsoft SQL Server 2008 Database Engine Services" to get the correct GUID.
  • For SQL 2005 you can search for "Microsoft SQL Server 2005" only to get the correct GUID

Solution 3


Get this via following TSQL Script

SELECT create_date as 'SQL Server Install Date',
DATEADD(dd,180,create_date) as 'Will Stop Working ON'
FROM sys.server_principals WHERE name='NT AUTHORITY\SYSTEM'

OUTPUT

When SQL Server Evaluation Edition will Expire ? when sql server server evaluation edition going to stop working The evaluation period has expired for this evaluation version of SQL Server sql server Event ID: 17052 SQL Server evaluation period has expired 17052 SQL Server evaluation period has expired How can I know when sql server 2005 Evaluation Edition will Expire Expiration Date of SQL Server Evaluation Edition Event ID: 17052 sql server

EOF - When SQL Server Evaluation Edition will Expire ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.