Maximum number of users that can simultaneously log in SQL 2016

  • SQL_Hunt

    SSC-Dedicated

    Points: 33450

    Hello,

    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. The default is 0, which means that the maximum (32,767) user connections are allowed. What happens if the total number of connections on any promotional events are more than 32,767? How SQL Server will be able to handle the situation?

    Any guidance would be helpful.

    Thanks.

  • Site Owners

    SSC Guru

    Points: 80376

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply