Home » CodeProject » How to Check SQL Server Evaluation Version Expire Date ?

How to Check SQL Server Evaluation Version Expire Date ?

SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The expiration date is always 180 days from the initial installation date.

The following query will give you the expiration date of evaluation instance :

SELECT

@@SERVERNAME SERVERNAME,

CREATE_DATE ‘INSTALALTIONDATE’,

SERVERPROPERTY(‘EDITION’) ‘Version’,

DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’

FROM SYS.SERVER_PRINCIPALS

WHERE SID = 0X010100000000000512000000

SID 0X010100000000000512000000 is associated with login “NT AUTHORITYSYSTEM” & which is created at the time of installation only.

If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)


11 Comments

  1. ArthurZ says:

    Or you can simply peek into the Start Time value in %Program Files%Microsoft SQL Server110Setup BootstrapLOGSummary.txt file and add 180 days to it.

  2. Deepak Mansukhani says:

    I personally prefer looking into the registry.
    Thanks Good one.

  3. Fazar says:

    Thank You.

    SELECT
    @@SERVERNAME SERVERNAME,
    SERVERPROPERTY(‘Edition’) AS Edition,
    CREATE_DATE ‘INSTALALTIONDATE’,
    SERVERPROPERTY(‘EDITION’) ‘Version’,
    DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’
    FROM SYS.SERVER_PRINCIPALS
    WHERE SID = 0X010100000000000512000000

  4. bệnh ung thư phổi says:

    You could certainly see your skills within the
    work you write. The arena hopes for more passionate writers like you who are not afraid to say
    how they believe. At all times follow your heart.

  5. janardhan says:

    After SQL Server Evaluation Edition period expired.. How can we continue or how we have to renew the licence of SQL server 2014??.

  6. Amado says:

    I see your page is similar to my page. Do you allow guest posting?

    I can write interesting & unique posts for you.
    Let me know if you are interested.

  7. Darkman says:

    It’s NOT WORKING !!!!!!

    Msg 208, Level 16, State 1, Line 1
    Invalid object name ‘SYS.SERVER_PRINCIPALS’.

  8. Bineesh Viswanath says:

    Modify above query like this:-

    SELECT

    @@SERVERNAME SERVERNAME,

    create_date ‘INSTALALTIONDATE’,

    SERVERPROPERTY(‘EDITION’) ‘Version’,

    DATEADD(DD, 180, create_date) AS ‘EXPIRY DATE’

    FROM SYS.SERVER_PRINCIPALS

    WHERE SID = 0X010100000000000512000000

Leave a Reply

Join us on Facebook

microsoftcommunitycontributor
%d bloggers like this: