Post reply

How do you determine SQL Server Licensing on all versions of SQL Server

  • December 8, 2010 at 10:16 am

    #228305

    We have several different versions of SQL Server install...2000, 2005 and now 2008. We are trying to do an audit to ensure we are compliant.

    I read a blog to run this for 2000:

    select serverproperty('LicenseType') as Licence_type

    and

    select serverproperty('NumLicenses') as Num_of_licences

    I ran then ran the same sql on 2005 and got a result of disabled:

    select serverproperty('LicenseType') as Licence_type

    I also ran this on 2005 and got a result of null:

    select serverproperty('NumLicenses') as Num_of_licences

    So how can I determine?

  • December 8, 2010 at 10:40 am

    #1260213

    You'll have to inventory your licenses (invoices, install media) and compare that to an inventory of installed instances.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 8, 2010 at 11:24 am

    #1260238

    That doesn't tell me if it is licensed per cpu or by cals.

  • December 8, 2010 at 11:59 am

    #1260256

    There is nothing in SQL Server 2005 or later to tell you how they were licensed.

  • December 8, 2010 at 12:02 pm

    #1260260

    Thanks that is sort of what I am finding. I found this blog that says that. If you want to use the above sql you have to update the registry with the information.

    http://blogs.msdn.com/b/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx

    Thanks.

  • December 11, 2010 at 4:42 pm

    #1261353

    As Michael mentioned, there is no way to get the licensing info from the SQL Server.

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 6 posts - 1 through 5 (of 5 total)

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