To get the installation time for SQL Server

When you install SQL Server 2014 recently. There is no formal license, only can be tried for 3 months. When you want to know when to expire, you need to know when SQL Server 2014 was installed. Suppose you didn't deliberately record the installation date (most people wouldn't). So is there a way to query from SQL Server? Think of the installation, we will certainly have the Windows Authentication login account creation information, we can query it to determine the installation date.

The query's T-SQL is as follows:

SELECT * from SYS. Server_principals

The results of its output are as follows:

From the results, we can see the create_date column, for example, by the name of the NT AUTHORITY\SYSTEM login account creation date, you know the installation date of SQL Server.

To get the installation time for SQL Server