1

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.

Regards.

Improve this question

2 Answers 2

Reset to default
4

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.)

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .