• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

SQL Server 2005 CAL shortfall

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
Amiga500
Asked:
Amiga500
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now