Determining how SQL is licensed

I have a number of servers with SQL some are SQL 2005 and some are SQL 2008.  I've been tasked with determining what type of license they have.  CALs,  or Processors.  How do you accomplish this?  I'm not a DBA so I'm not sure how to run a query if  necessary.
WellingtonISAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Those License properties are not used as you can see in this article:

LicenseType - Unused. License information is not preserved or maintained by the SQL Server product. Always returns DISABLED.

NumLicenses - Unused. License information is not preserved or maintained by the SQL Server product. Always returns NULL.


You need to check how many instances do you have by server and group them by edition and server type (physical and virtual) so you can calculate the licenses following Microsoft license model. More information here.
0
 
Scott PletcherSenior DBACommented:
Try:

SELECT SERVERPROPERTY('LicenseType')

Although often you'll just get back "disabled", because SQL was loaded from a "master install" copy.
0
 
WellingtonISAuthor Commented:
OK so that's not going to help me?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Scott PletcherSenior DBACommented:
It might, run it and see.
0
 
WellingtonISAuthor Commented:
this is about what I had to do.  It's not the exact answer for according to the information I got you can't determine what the license is after the fact. however, the general rule is if it's more that 90 users then you should go with processor licenses.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to try to consolidate as much you can. Specially move from physical servers to virtual. With this you'll save a lot of money only in licensing and also it's a good opportunity to get rid of old servers.
0
 
WellingtonISAuthor Commented:
Yep that's what I'm in the process of trying to do. the only thing stopping me is $$$$..
0
 
Scott PletcherSenior DBACommented:
>> Those License properties are not used as you can see in this article <<

Not for SQL 2005 and SQL 2008; they could still be there for versions, depends on how SQL was installed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.