Hi..
i have an application in dot net 2.0 and have a database of sql server 2000.
working very fine till today but suddenly an error come and was
time out to connect with server and that issue is coming again and again...
but one thing is here that database contains more than 800000 records.
can any one help me..
Loading
Suthish NairPosted Oct 11, 2011, 1:51 PM
Prabhu RajaPosted Oct 10, 2011, 3:09 AM
I think its not a problem Of sql server.
Check Your Connection String used in Application, if you used Timeout Parameter, then Increase Your Timeout Limit by something or remove the timeout parameter and Check.
Abhimanyu K VatsaPosted Oct 10, 2011, 2:27 AM
1. open sql server enterprise managr and find the server that contains your database.
2. right click on the server name and select properties
3. choose the connections tab
4. increase the query timeout value, set it to 0 for unlimited time
5. click ok
try it.
Sam HobbsPosted Oct 9, 2011, 8:48 PM