SQL Server License identification

Question

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.

score 4 · Answer 1 · answered Mar 13 '12 at 22:23

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

Thanks Evan for the reply. Any idea about the manual p[rocess?? — ZINX, Mar 13 '12 at 22:29

score 0 · Answer 2 · answered Mar 13 '12 at 23:25

0

SELECT DISTINCT login_name FROM sys.dm_exec_sessions

answered Mar 13 '12 at 23:25

adaptr

16,576
23
34

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

SQL Server License identification

2 Answers2