Solved

Determining how SQL is licensed

Posted on 2015-01-21
8
109 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
  • 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 47

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 47

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 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