Solved

Determining how SQL is licensed

Posted on 2015-01-21
8
115 Views
Last Modified: 2015-01-23
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
Comment
Question by:WellingtonIS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40563112
Try:

SELECT SERVERPROPERTY('LicenseType')

Although often you'll just get back "disabled", because SQL was loaded from a "master install" copy.
0
 

Author Comment

by:WellingtonIS
ID: 40564076
OK so that's not going to help me?
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40564289
It might, run it and see.
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40566261
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
 

Author Closing Comment

by:WellingtonIS
ID: 40566302
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
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40566313
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
 

Author Comment

by:WellingtonIS
ID: 40566316
Yep that's what I'm in the process of trying to do. the only thing stopping me is $$$$..
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40566607
>> 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2008 R2 service pack updates 5 61
Database maintenance 36 136
Estimating my database size 7 51
What is needed to become a DBA? 7 52
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question