>Is there a way to limit the number of users than can access a database in SQL Server? We license our software based on the number of concurrent users, and we want to enforce that limit. Basically, I need to know how many users are logged in to a database.
>
>Thanks.

Joel,

You'll get error number 18458 (All licensed connections are in use) from SQL Server, whenever someone tries to connect when the number of licenses are maxed out. I know that this doesn't specifically answer your question, but when you periodically get this message it basically means that you need to purchase new CAL licenses.