How to check license information

  • Hi Friends,

    What is the best way to get the information regarding the SQL Server licenses in our environment. We need to get the information as serverName, edition & licenseType (client/server) etc.

    Any help is appreciated. 🙂


    Sujeet Singh

  • SQL doesn't keep track of how it's licenced, that's paperwork. (other than SQL 2012 in one case)

    As for server name, version and edition, have a look at the MAP tool from Microsoft.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • With difficulty, 2005 onwards, SQL doesn't store if it is proc/core or server/cal licensed, it is up to you to assign licenses logically to ensure your server estate is covered and complies with MS licensing regulations.

  • GilaMonster (12/18/2012)


    SQL doesn't keep track of how it's licenced, that's paperwork. (other than SQL 2012 in one case)

    As for server name, version and edition, have a look at the MAP tool from Microsoft.

    Thanks a lot Gail & Anthony. I am looking at MAP tool & it seems very useful. Appreciate it 🙂


    Sujeet Singh

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply