SQL Server 2019 Datacenter Editon ?

Question

SQL Server 2019 Datacenter Editon ?

TonyJK 881

Hi,

Vendor says that our SQL Server is running Datacenter Edition that is not supported. However, I find that there are only Standard Edition and Enterprise Edition available for SQL Server 2019. Is it correct ?

I also find out the version we are running
Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64)
Mar 22 2021 18:10:24
Copyright (C) 2019 Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: )

Thanks

Accepted answer

2 additional answers

Your answer

Answer 1

Olaf Helper 47,436

Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763:

Your Windows Server OS is a Datacenter Edition, your SQL Server is a Standard Edition.

Answer 2

Hi @TonyJK ,

>However, I find that there are only Standard Edition and Enterprise Edition available for SQL Server 2019. Is it correct ?

For paid license of SQL server, yes, you are correct. But there are also free edition, such as Express edition. Below screenshot is the editions for SQL server 2019.

Refer to MS document SQL Server editions.

> Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64) Mar 22 2021 18:10:24 Copyright (C) 2019 Microsoft Corporation
>Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: )

The result is from select @@version query, according to the result, your SQL server edition is standard. Datacenter is Windows Server 2019 Datacenter edition not SQL server.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 3

Tom Phillips 17,771

I suggest you point your vendor to this document:
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-server-ver15#operating-system-support

Or they may actually be saying "their software is not supported on SQL 2019".

TonyJK 881 Reputation points

2021-07-31T04:07:18.933+00:00

Dear Tom,

Forget to mention that the Server running SQL Server is different from the Application Server. They have problem connecting to the Database Server.

They suggest either changing to SQL Server 2019 Enterprise Edition or install SQL Server 2019 Standard on the Application Server.

We guess it is a connection problem and not SQL Server Edition compatibility issue.

Thanks again
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2021-07-31T08:08:47.483+00:00

Forget to mention that the Server running SQL Server is different from the Application Server. They have problem connecting to the Database Server.

>

They suggest either changing to SQL Server 2019 Enterprise Edition

It would be interesting to know why they think that would help. It sounds like total nonsense to me. Or more bluntly: they don't know what they are talking about.

We guess it is a connection problem and not SQL Server Edition compatibility issue.

Your guess seems spot on to me. Perform the usual checks. Is SQL Server configured to accept connections on TCPIP?. Firewalls? Browser service running etc.
TonyJK 881 Reputation points

2021-08-02T00:13:13.393+00:00

Dear Erland,

The vendor is a leading "Network Performance Monitoring" software provider.

Thanks
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2021-08-02T08:26:18.847+00:00

Oh-oh. Well, it does not make it sound less nonsense to me.
TonyJK 881 Reputation points

2021-08-18T10:43:13.31+00:00

I am not saying that they are right but just feel a bit frustrated as they make such statement.
Tom Phillips 17,771 Reputation points

2021-08-18T14:56:21.333+00:00

The SQL edition has nothing to do with connecting to SQL Server.

What exactly is the error message you are receiving?

Share via

SQL Server 2019 Datacenter Editon ?

2 additional answers

Your answer