allow limited number of client connected on the server

From: Dany Duchesne (anonymous_at_discussions.microsoft.com)
Date: 11/27/03 

Date: Wed, 26 Nov 2003 19:17:34 -0800

Hi

I want to allow limited number of client simultaneously
connected on the server. I used this script:

USE corpo
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configure

EXEC sp_configure 'user connections', '1'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure

After I restarted the server, I still can make many
connection. What is the script that I need to set the
maximum connection simultaneously on the server?

thank

Dany

Relevant Pages