govindarajan69 (4/21/2014)
Hi All,Our company procured MS SQL Server 2008 R2 with 5 CAL. I installed MS SQL Server 2008 R2. How to ensure that only 5 CALs are used. It is used for our internal access control system.
Kindly give some advise on this.
Regards
Rajan
You can't do this. You can write a process that looks for > 5 users and disconnects some, but that would have to run constantly and scan.
You can also write a method in the login for your application that prevents a 6th person from logging in by checking how many users are logged in. However this won't prevent a 6th person from logging into SQL Server with Excel, SSMS, etc.