SQL Server returns wrong OS version on Windows 11

Question

I use an SQL statement to get the underlying OS and OS version of my SQL Server 2019.

This works fine for all versions of Windows ... except Windows 11.

SELECT @@VERSION AS OS

results on a fresh Windows 11 machine (Windows 11 Enterprise - Build 22000.469) in the string

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23   Copyright (C) 2019 Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22000: ) (Hypervisor)

Is this a bug? Or what's going on here?

And how can I get information to distinct Windows 10 from Windows 11? Do I have to parse the build number and interpret build numbers >= 22000 as Windows 11?

I am surprised you got that installed at all. SQL Server Enterprise edition isn't supported on Windows 11 (regardless of the version). Operating system support — Thom A
– Thom A ♦, Commented Feb 4, 2022 at 15:32
Microsoft has never been good with version numbers - you should try figuring out the installed versions of .NET Framework sometime. Windows 11 is still version 10, build 22000 (and later). — AlwaysLearning
– AlwaysLearning, Commented Feb 4, 2022 at 15:35
Successive versions of windows have taken to lying with older API calls to discover version information because other programmers (probably both others within MS and third parties) keep churning out more and more code that makes hard coded decisions based on returned values, ignoring that any future version will ever exist. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Feb 4, 2022 at 15:35
What info do you get from select * from sys.dm_os_host_info — Charlieface
– Charlieface, Commented Feb 4, 2022 at 16:47

David Browne - Microsoft · Accepted Answer · 2022-02-04 18:07:58Z

5

Is this a bug? Or what's going on here?

SQL Server 2019 does not know how to tell the difference between Windows 10 and Windows 11 because Windows decided not to increment the "major" component of the build number for the release. It's 10.0.22000.

This is closely related to the reason SQL Server works perfectly on Windows 11. Windows no longer introduces breaking changes. And it's long been the policy of SQL Server to support new versions of Windows for supported versions of SQL Server on release. The support matrix in the docs sometimes lags, but you can generally open a support case for SQL Server on the latest version of Windows.

Perhaps a future release will implement the logic to differentiate between Windows 10 and Windows 11.

edited Feb 4, 2022 at 18:07

answered Feb 4, 2022 at 15:56

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thom A Over a year ago

"The support matrix in the docs will be updated eventually" The matrix is updated. All editions of SQL Server 2019 apart from Enterprise are supported on Windows 11. Enterprise isn't supported on Windows 10 either; never has been.

David Browne - Microsoft Over a year ago

Yeah, it's not supported to use Windows 10/11 as a server, so running EE is discouraged.

Yitzhak Khabinsky · Accepted Answer · 2022-02-04 20:44:25Z

0

There is a DMV for it.

Check it out.

SQL

SELECT * FROM sys.dm_os_host_info;

Output

+---------------+--------------------------------+--------------+-------------------------+----------+---------------------+-------------------+
| host_platform |       host_distribution        | host_release | host_service_pack_level | host_sku | os_language_version | host_architecture |
+---------------+--------------------------------+--------------+-------------------------+----------+---------------------+-------------------+
| Windows       | Windows Server 2019 Datacenter |         10.0 |                         |        8 |                1033 | X64               |
+---------------+--------------------------------+--------------+-------------------------+----------+---------------------+-------------------+

answered Feb 4, 2022 at 20:44

Yitzhak Khabinsky

22.7k2 gold badges19 silver badges25 bronze badges

1 Comment

Peter Vandivier Over a year ago

This DMV will not tell you if you're on Win 11 for the reasons given in the accepted answer.

Collectives™ on Stack Overflow

SQL Server returns wrong OS version on Windows 11

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related