February 12, 2009 at 9:02 am
I purchased a SQL 2005 server with 20 User Cals. In the hundreds of installation I've done, this is the first.
I can't for the life me figure out where to limit the user connection to 20 User Cals.
In SQL 2000, it was a no brainer. I hope I'm just overlooking something.
DBA in distress!!!!
February 12, 2009 at 11:14 am
Right click on the server and go to properties. Click on the Connections tab on left and there the first option is to set the max allowed connections.
The default is set to 0 which means unlimited connections. You can change it to 20 and may need to restart SQL server for this change to take effect.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 11:29 am
Thanks so much for the info.
When installing SQL 2000, if you used "seats" instead of "processors", this connections settings would be set to that value?
Arun.
February 12, 2009 at 11:33 am
arun.modasra (2/12/2009)
Thanks so much for the info.When installing SQL 2000, if you used "seats" instead of "processors", this connections settings would be set to that value?
Arun.
No. You could still have more than 20 users connect to your database. You would just see in one of the logs that you had more users connecting than you were supposed to.
If you set the number of connects to 20 that should be all the connects that will be allowed. You could have all 20 connections taken by one user doing this.
February 12, 2009 at 1:24 pm
You cannot limit by CALs. CALs are an administrative thing only; there's no setting in SQL to track this. Many applications might open more than one connection (like SSMS), so limiting to 20 connections might cause you issues.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply