Click here to Skip to main content
15,916,280 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
My problem is that i have a web application in .net on dedicated windows server 2008
with one database sqlserver 2008.

One database name is XYZ with userid aaaaa and password 123456
another database which is connceted above application is also access with same userid and password.

but sometime this application is disconnect with sqlserver again-2 ..
my connection string is this..

add name="ConnectionString" connectionstring="Database=YYY;Server=;UID=aaaaa ;PWD=123456; pooling=true; Max Pool Size=200;Connect Timeout=200" providername="System.Data.SqlClient"

this problem occur when no of user access one page is increased

What is possible reasion of this problem and please suggest any solution ..

Updated 19-Mar-12 3:18am
Sushil Mate 19-Mar-12 8:55am    
You need to elaborate more your problem. It could be timeout for the disconnecting SQL server.
AmitGajjar 19-Mar-12 8:58am    
is your application going into an idle mode for long time ?
ZurdoDev 19-Mar-12 10:09am    
I don't understand what you are saying. What does "but sometime this application is disconnect with sqlserver again" this mean?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900