SQL Server 2008 Expiry Date Find

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".

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\\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