Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 131
  • Last Modified:

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.
0
WellingtonIS
Asked:
WellingtonIS
  • 3
  • 3
  • 2
1 Solution
 
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
 
Scott PletcherSenior DBACommented:
It might, run it and see.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Vitor MontalvãoMSSQL 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
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now