Solved

SQL Server 2005 CAL shortfall

Posted on 2011-09-13
2
325 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 59

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 59

Accepted Solution

by:
Kevin Cross earned 500 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now