Solved

Determining how SQL is licensed

Posted on 2015-01-21
8
119 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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

696 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