Click here to Skip to main content
14,269,998 members
Rate this:
Please Sign up or sign in to vote.
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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100