We have a web application which needs big number of database connections. whenever we are trying to publish sites it is failing and when we invistigated it we found that SQL server policy is accepting 300 database connections as our vendor said & we need to increase the number of database connections.
I have opened the Managment Studio, right click on the server, properties the I moved to connections tab and I found the maximum number of concurrent connections is "0" which supposed to mean unlimited number of connections
I contiued my invistigation and I found that due to a security feature of Windows Server 2003, Windows may drop connections if the requests arrive faster than SQL Server can service them in order to avoid server SYN flood. This security feature implements a finite queue for incoming TCP connection requests which results in the following error:
ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing connection was forcibly closed by the remote host ...
What I need to know how I can increase the number of database connections and what are the side effects (if there any?)
Please help me it is an urgent issue