Maximum number of users that can simultaneously log in SQL 2016

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  June 6, 2020 at 2:44 am

  #3761001

  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: 80320

  More actions

  June 7, 2020 at 3:10 am

  #3761143

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

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