Share via

How do I retrieve License Information(Software Assurance specifically) for my Microsoft SQL server ( 2012 Standard)

Shubh Garg 20 Reputation points
2023-06-05T06:34:02.36+00:00

I have a "Microsoft SQL Server 2012 (SP4-GDR) (KB4583465)" standard edition installed on my Windows Ec2 instance (not AWS license, it is BYOL.) I do not have the information or ID to login to Microsoft volume licensing website(https://help.connectingup.org/hc/en-us/articles/115006421587-What-is-Microsoft-Software-Assurance-and-how-do-I-access-it-#:~:text=Sign%20into%20the%20Volume%20Licensing,for%20all%20your%20licensing%20IDs.) or any information of credentials that i can use to get licensing information(Microsoft Licensing Portal).

I have SQL full access and Server Access(Admin) as well.

tried retrieving it from Server Manager at first, but could not find any license option.

Tried retrieving from SSMS 2018 as well but could not find it in properties or by running sql commands that i could find.

Please suggest me ways with which i can retrieve this information.

Windows for business | Windows Server | User experience | Other
SQL Server | Other
Accepted answer
  1. Anonymous
    2023-06-05T07:49:51.7433333+00:00

    Hi @Shubh Garg

    From what I've searched, SQL Server hasn't tracked licenses since many years ago (before SQL Server 2008), and doesn't store license information in SQL Server at all. You will need to keep track of your license documents or proof of purchase yourself. You can retrieve the product key from the registry.

    For more details, you can refer to these links: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/42b03abd-cc56-4236-8e70-158c1dfb3dab/how-to-check-the-sql-server-license-which-i-installed?forum=sqlsecurity

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/42b03abd-cc56-4236-8e70-158c1dfb3dab/how-to-check-the-sql-server-license-which-i-installed?forum=sqlsecurity.

    For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.

    Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.

    Best regards,

    Aniya

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,441 Reputation points
    2023-06-05T07:58:54.16+00:00

    SQL Server don't stored license informations (beside the Edition), you have the licenses only on "paper".

    1 person found this answer helpful.
  2. Limitless Technology 44,766 Reputation points
    2023-06-05T10:11:08.8366667+00:00

    Hello Shubh,

    Thank you for your question and for reaching out with your question today.

    You can retrieve the SQL server version but not the license information by doing the following:

    Open a Command Prompt. Connect to your SQL Server instance by executing this command:

    SQLCMD -S server_name\instance_name

    Where server_name is your server name and instance_name is the SQL instance name. If you’re trying to connect to the default instance, just type SQLCMD.

    Next, run the following T-SQL query:

    select @@version

    go

    This will display the version and license type of your connected SQL Server instance. If you have multiple instances, use the same method to check each instance.

    The license information is not available on later versions of SQL Server.

    If the reply was helpful, please don’t forget to upvote or accept as answer.

    0 comments

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.