Solved

SQL Server 2005 CAL shortfall

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Question about AD permissions 2 70
How to run the DNS query from the server? 5 77
Dentrix G4 1 65
PowerShell one liner to pull server names 3 61
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

832 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