SQL SERVER MAXIMUM NUMBER OF CONNECTIONS LIMIT BYPASS

CHRISTOS STAVRINOU 26 Reputation points
2020-10-05T06:19:31.697+00:00

Hi,

By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance.

How to bypass this limit. What is an alternative solution to connect more users.

Thank you for your answer.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,818 questions
0 comments No comments
{count} vote

Accepted answer
  1. m 4,271 Reputation points
    2020-10-05T08:00:42.78+00:00

    Hi @CHRISTOS STAVRINOU ,

    ...How to bypass this limit. ...

    You can't by pass this limit. For one instance, if you exceed the maximum number of user connections, you receive an error message and are not able to connect until another connection becomes available.

    ...What is an alternative solution to connect more users.

    However, if you have more connections,one solution is you can install more instances in the server. SQL Server supports 32,767 connections per instance. You can run 50 instances per node, so the maximum number of client connections per server node is 32767*50. (Note: please check the version of your sqlserver firstly, max number per server node is 32767 * Max Instance Numbers)

    Please reference: configure-the-user-connections-server-configuration-option, maximum-capacity-specifications-for-sql-server

    And another solution is the reply from this case: connection-limit-of-32767

    Another solution is to use multiple SQL Servers, arranged in some order to limit connections (Department, Location, etc), and MERGE replication to keep all copies up to date.

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.


1 additional answer

Sort by: Most helpful
  1. Shashank Singh 6,251 Reputation points
    2020-10-05T08:22:58.29+00:00

    How to bypass this limit. What is an alternative solution to connect more users.

    Are you sure you would reach that limit. Please understand that a session can let you execute multiple request which is called as Multiple Active Result Set. Also a connection can have multiple sessions associated with it and this can be easily achieved by connection pooling.

    I can easily show you connection exceeding 32767 see this thread. This is possible by connection pooling. I would not worry about bypassing the limit since we have connection pooling which would easily bypass this ( it looks like it is bypassed but actually "physical" connection limit is still 32767).

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.