Maximum number of SQL Server user connections

Use the user connections option to specify the maximum number of users allowed to connect to Microsoft SQL server at the same time. The actual number of user connections allowed depends on the SQL Server version in use and the application.ProgramAnd hardware restrictions. SQL Server allows up to 32,767 users to connect at the same time.

Because user connections is dynamic (automatic configuration options), SQL Server will automatically adjust the maximum number of users connected to the user as needed, and the maximum cannot exceed the allowed maximum. For example, if only 10 users log on, 10 user connection objects are allocated. In most cases, there is no need to change the value of this option.

You can use the SQL query analyzer and the following statements to determine the maximum number of user connections allowed by the system:

Select @ max_connections