Wednesday, July 18, 2012

Unlimited Connection TimeOut in Asp.net and SQL

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

For Asp.net 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.

3 comments:

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

    ReplyDelete
  2. Useful tips to avoid this problem.

    ReplyDelete