How to find Windows OS version from SQL Server

Nenea Nelu 61 Reputation points
2024-02-08T16:15:33.94+00:00

Trying to find out the operating system version on some of the SQL Servers where I do not have RDP admin access yet I execute the SELECT @@Version TSQL command which returns:

"Microsoft SQL Server 2014 (SP2-CU17-GDR) (KB4505419) - 12.0.5659.1 (X64) May 24 2019 19:09:40 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 20348: ) (Hypervisor) " Under SQL Server Properties I can see the Operating System: "Microsoft Windows NT 6.3 (20348)" however...after a internet search on this particular strings I cannot find what the actual OS version my SQL Servers are running on. Can anyone please tell what this version is or maybe point to a site that helps finding it by the above strings??? All I found related to Windows NT 6.3 points to Windows 8.1 but I know that is not true.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,324 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,754 questions
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 52,831 Reputation points
    2024-02-08T16:31:39.69+00:00

    you can use the link to see its windows 8.1 or server 2012 r2 variant:

    https://learn.microsoft.com/en-us/windows/win32/sysinfo/operating-system-version

    note: both are out of support

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Javier Villegas 895 Reputation points MVP
    2024-02-08T18:32:27.7266667+00:00

    Hi @Nenea Nelu you can try this DMV calling it using below T-SQL code Regards Javier

    SELECT host_platform, host_distribution, host_release
    FROM sys.dm_os_host_info;
    GO