Wednesday, July 18, 2012

Unlimited Connection TimeOut in and SQL

Sometimes when we are executing a Stored procedure from which takes a lot of time,which leads to connection TimeOut problem.
There are two ways to increase connection TimeOut.
1) From Web.config
2) From Sql Server database setting.

For got to web.config connection string and set Connection timeout Property to 0(Zero).

For Sql Server right click on Server => Properties . then a server properties page will open , from left hand side menu select Connections and set Remote query timeout to 0.

I hope somebody will find this useful.


  1. Hey Sql server time out setting really solve my long time timeout issue. Thanx buddy.

  2. Useful tips to avoid this problem.