Purpose

The purpose of this article is to teach you the process of setting up user connections in Microsoft SQL Server 2000.

Setting up User Connections

User connections option is used to specify the maximum number of simultaneous user connections allowed on Microsoft SQL Server. The actual number of user connections allowed also depends on the version of SQL Server you are using and the limits of your application(s) and hardware. SQL Server allows a maximum of 32,767 user connections.

Following steps describe you the step by step details of setting up user connections:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click on registered SQL Server i.e. PC54, then click Properties, and click Connections tab.

3. Under Connections tab, set a value for Maximum concurrent user connections (0 = unlimited) option.

4. Click OK.