Microsoft SQL Server : How to find the maximum simultaneous user connections allowed

Question

I am getting "MaxConnections quota reached" error while running an application that uses SQL server database.How can I find the maximum number of simultaneous user connections allowed on an instance of SQL Server?

Answer 1

Run the following SQL to see the maximum number of connections allowed.

SELECT @@MAX_CONNECTIONS AS 'Max Connections';