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,
Amiga500Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.