How do I set the maximum number of connections for SQL Server

intgis

I would like to ask how to set the maximum number of connections sql server, I want to increase the number of connections, thank you!

cv4bf5d65fd

Right-click the database server -> Properties can be changed

dream88

Can be set by yourself, set to 0 means unlimited

fanfan1980

--try

USE master
EXEC sp_configure'user connections','value'
RECONFIGURE WITH OVERRIDE

wgfxman

UP, all answered upstairs

Maximum number of concurrent connections (0 = unlimited)
If set to a non-zero value, it will limit the number of connections allowed by Microsoft SQL Server.

Note:
If you set this value to a lower value (such as 1 or 2), it may prevent administrators from connecting to manage the server; however, the "dedicated administrator connection" can always connect.

intgis

Thank you