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 | Other
{count} votes

Accepted answer
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    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
  1. Anonymous
    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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.