I have a database on SQL Server. My web application contacts this database. Is there a way in which I can restrict the number of connections to this database through some settings on the SQL Server?
Seems like we can do it :
To configure the user connections option
- In Object Explorer, right-click a server and click Properties.
- Click the Connections node.
- Under Connections, in the Max number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect simultaneously to the instance of SQL Server.
- Restart SQL Server.