Determine SQL Licensing Type after installation

Bela de Souza 20 Reputation points
2024-03-28T15:59:59.69+00:00

Hello,

From the Microsoft Volume Licensing Center, I downloaded both Server/Cal and PerCore SQL Server 2022 Standard Edition download (ISO) files and placed them in separate folders, not realizing they were saved with the same name.

A coworker installed SQL from one of those two folders but cannot recall which one it is. We are now unable to tell which licensing model we are using in the installed SQL Server, since my co worker does not remember from which folder he ran the installation file (and both files have the same name). We need to know which licensing type is being used so we can report it properly to Microsoft.

How can we tell which licensing type our SQL Server installation is using? I've done extensive research and could not find a way to determine this.

Thanks in advance!

Bela

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,716 questions
Accepted answer
  1. Erland Sommarskog 101K Reputation points MVP
    2024-03-28T22:12:10.8766667+00:00

    You can run SELECT SERVERPROPERTY('LicenseType') - and you will find that it returns DISABLED. Or as the documentation says:

    Unused. License information is not preserved or maintained by the SQL Server product. Always returns DISABLED.

    I don't know why there are different ISO, but I believe you should be able to report the one you want to use. The license is a paper-matter only.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChen-MSFT 965 Reputation points Microsoft Vendor
    2024-03-29T06:34:58.9533333+00:00

    Hi @Bela de Souza,

    Thanks for your information. Here is an issue similar to yours: https://stackoverflow.com/questions/4099453/how-do-i-find-out-what-license-has-been-applied-to-my-sql-server-installation.

    Hope this article can help you understand the property information to be returned for the server.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications