Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers

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
add comment
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
1  
Device CALs are CALs. User CALs are CALs. Differentiate based on the query above. –  Evan Anderson Mar 13 '12 at 23:41
add comment

Your Answer

 
discard

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.