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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,298 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,582 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    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
  1. Olaf Helper 43,161 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,101 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 No comments