Post reply

licensing audit

  • July 14, 2009 at 11:02 am

    #155961

    So I recently found out that the serverproperties LicenseType and NumLicenses are not used in SQL Server 2005.

    I'm sure there must be a way to determine the licensing model on our servers after the install.

    I want to make sure we are in full compliance, but not sure how to determine which licensing model was used, and if it is CAL licenses how many were specified during install.

    Can anyone help?

  • July 15, 2009 at 12:17 am

    #1024822

    Hello Chris,

    Check this in regedit

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\MSSQLLicenseInfo\MSSQL9.00

    if Mode value is 0 and ConcurrentLimit 10 than client lincenses is for 10.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • July 16, 2009 at 1:27 am

    #1025498

    Chris,

    Its there in 2005 too.

    http://msdn.microsoft.com/en-us/library/ms174396(SQL.90).aspx

    MJ

  • July 16, 2009 at 10:03 am

    #1025760

    MANU (7/16/2009)

    Chris,

    Its there in 2005 too.

    http://msdn.microsoft.com/en-us/library/ms174396(SQL.90).aspx

    MJ

    It is there, but the "correct" values are not there,ie "LicenseType" is DISABLED and "NumLicenses" is NULL because, at least with a fresh install, there is no place to provide the licensing info.

    You would have to manually track this information......

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

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

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