Post reply

How to check license information

  • December 18, 2012 at 4:06 am

    #286616

    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

  • December 18, 2012 at 4:08 am

    #1569464

    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

  • December 18, 2012 at 4:10 am

    #1569467

    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.

  • December 18, 2012 at 5:02 am

    #1569489

    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