Exceed the maximum number of users

Hi,
I have a question regarding the maximum number of concurrent
users of MS SQL Server.
If I use 5-user SQL Server, and already 5 users are connected
to the server, and 6th user tries to connect to the server,
then what will happen to the 6th user?
Will he/she get an error like "connection rejected" immediately, or
will he/she be on a queue until another user will disconnect
from the server?
Thank you,
Brady"Brad J." <bradyketteth@.yahoo.com> schreef in bericht
news:bbdf5c2c.0310302258.9300496@.posting.google.com...
> Hi,
> I have a question regarding the maximum number of concurrent
> users of MS SQL Server.
> If I use 5-user SQL Server, and already 5 users are connected
> to the server, and 6th user tries to connect to the server,
> then what will happen to the 6th user?
> Will he/she get an error like "connection rejected" immediately, or
> will he/she be on a queue until another user will disconnect
> from the server?
> Thank you,
> Brady
Hi Brad,
You can test this: open 5 different Query Analyzer to the same server and
try to connect with the 6th. I do know you will get a warning in the event
log.
Regards,
Gerry