Maximum number of user connections
Posted on 1998-01-12
We´ve got a diinamic web application on IIS which accesses to a SQL Server in the same machine. The problem is that after browing it for a while an error happens:
the number of 30 user connections has been reached, use sp_configure to change the maximum number of user connections.
When I opn the Enterprise Manager, the maximum number of user connections is 32.767.
The asp´s of my application use ODBC. Is there a limit of ODBC user connections to a SQL Server database. Is it a problem of configuration?