how to increase sql 2005 server database number of connections?

Hi,
  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
DWTCITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
SQL server allows a maximum of  32,767 connections..
And change it to either 600 or 1000 and check it out..

Another workaround would be to fine tune your existing queries, so that they execute faster releasing the connections to waiting users..
0
DWTCITAuthor Commented:
That means if I keep it 0 will it give me 32,767 connections? or it is better to set it as "32,767"
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Keeping it to 0 allows a maximum of 32767 by default..
If you are sure that you need more no. of connections say, 600 or 800 then specify it over here for better performance.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.