On a machine that is running IIS 6.0 and SQL Server 2005, where are the different locations that can limit the max number of database connections?
SQL Server max connection settings
iis-6sql-server-2005
iis-6sql-server-2005
On a machine that is running IIS 6.0 and SQL Server 2005, where are the different locations that can limit the max number of database connections?
Best Answer
If by "number of connections" you mean the size of the connection pool, then this applies:
Source: SQL Server Connection Pooling (ADO.NET)
The default size of connection pools is 100. You can change that size in in the connectionstring itself, but you should have a good reason to do that. In most cases where you run out of connections, they are leaking (=not properly closed) in the application.