User connections limited to 4 with 5 user license

[Guest_imported]

We have SQL server running with 5 user license.
Yet, only 4 workstations can connect.

What's the deal here?

Thanks
Richard Shakour

 

[jnicho02]

Is one of those users using Enterprise Manager? This often uses up two connections.....go in using Query Analyzer and monitor connections using sp_who, although the output can be confusing sometimes as you see all the internal connections from the server as well. [sig]<p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br> [/sig]

 

[TomSark]

Yes... SINGAL_HANDLER, LAZY WRITER, LOCK MONITOR, CHECKPOINT, etc. all have their own SPIDs and maintain a connection to SQL Server. In addition, EM, Query Analyzer, profiler, etc. require a connection as well.


Tom [sig][/sig]

 

[Ruairi]

usually, all those processes that tom mentioned are running at all times. If they each gobbled up one liscence i would expect your available liscences for user connections to be a negative number. You can configure the number of user connections using sp_configure. Run this stored procedure from the querey tool in enterprise manager (dont use any parameters, just 'sp_configure'. This will list the max, min, run_value(the value sql server is currently using), and config_value(the value you have set, this will become the run value after stopping and restarting the server). look at the run value for 'user connections' is it set to 4? if so you can run

sp_configure &quot;user connections&quot;, 5
reconfigure

from the querey tool. If it is set to 5 or higher, maybe tom and jnicho02 are correct, i just don't see how it makes sense that you are losing one connection to all those seperate processes.
[sig]<p>Ruairi<br><a href=mailto:ruairi@logsoftware.com>ruairi@logsoftware.com</a><br>Experienced with: <br>
VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions<br>
ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications[/sig]