Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We purchased a SQL server license with 10 user CALS, a while ago. How can I identify the users accessing the SQL server to make sure number of CALS match the number of users accessing the server? Is there some tool to achieve this? or may be some manual process?

Please help.


share|improve this question

You're looking at a manual process. Microsoft gave up on automated license tracking for everything except Terminal Services years ago. There is enough "nuance" and interpretation in their licenses that no automated system can accurately count their usage. (In addition, I'd argue that they've eschewed automated license compliance mechanisms so that they can be free to "interpret" their licenses in litigation as they see fit. It would be pretty hard to argue that a Customer wasn't in compliance if Microsoft's own tool told the Customer that they were in compliance.)

share|improve this answer
Thanks Evan for the reply. Any idea about the manual p[rocess?? – ZINX Mar 13 '12 at 22:29
SELECT DISTINCT login_name FROM sys.dm_exec_sessions
share|improve this answer
Processor licenses? External connector licenses? Device vs user CALs? – Evan Anderson Mar 13 '12 at 23:32
He clearly said "Client Access Licenses". This means concurrent users. – adaptr Mar 13 '12 at 23:34
Device CALs are CALs. User CALs are CALs. Differentiate based on the query above. – Evan Anderson Mar 13 '12 at 23:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.