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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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
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