[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server 2005 CAL shortfall

Posted on 2011-09-13
2
Medium Priority
?
343 Views
Last Modified: 2012-05-12
A client of ours has been contacted by Microsoft and asked to supply information on all of their Microsoft software.  We have done this and they seem satisfied that it all checks out, apart from the number of SQL User CALs.

The client uses Archetype and ACT on 13 PCs and I have checked that they have sufficient CALs to cover these.  However, MS are saying that they have 33 CALs installed.

The client just wants to be sure that they have got the right licences for all of their software so they want to either buy additional CALs  if they need them or remove the SQL User CAL from the machines that don't require it.

1. How do I check if a machine has a SQL User CAL installed?

2. How do I remove it if it is not needed?

3. How do I get a definitive list of all applications that require a User CAL?

Your help is much appreciated.

Thanks,
0
Comment
Question by:Amiga500
  • 2
2 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36540081
Hi.

See if this helps on question 3: http://www.microsoft.com/licensing/about-licensing/client-access-license.aspx#tab=2 and http://www.microsoftvolumelicensing.com/userights/.

For question 1 and 2, I usually go into Licensing (Start > Administrative Tools > Licensing); however, one question is how do you have Archetype and ACT setup as you stated they are on 13 PCs? Are the 13 PCs in fact accessing a dedicated SQL server? Or do you have individual copies of SQL 2008 Express installed on each PC. If the latter is the case, then you don't need CALs as Express is free. If you have a dedicated server, then what may be happening is that they are using device CALs and old PCs are still showing in the list. You should be able to delete those to reflect that there are truly only 13 active machines now.

Kevin
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 2000 total points
ID: 36540121
And a correction, clarification, to above. Licensing will show Windows CALs. SQL CALs won't show there IIRC. I have per processor licensing for a good number of years, so its been awhile since I have had a system with per seat.

See this post for some help on the registry key to check on SQL 2005: http://blogs.msdn.com/b/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
(this applies if you have a standalone SQL server or the PCs are using non-Express editions of SQL)

If PCs each are running SQL Server (non-Express), and each user has three accounts accessing their local SQL then your CAL requirements would be triple the number of PCs. That maybe how that number is coming up. Details on the exact setup will help determine that though. Guessing at this point.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

834 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