System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

all I am trying to resolve issue. where situation is, There is asp.net webservice. webservice is connected with the sql server. created for receiving the data. but while requesting to the webmethod, even in browser i am getting exception :

System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

AS per my understanding this must be issue about delaying in response from the server.Or due to time complexi开发者_如何学Cty in data fetching process in the method. I know we can specify the timeout for the sql command. but I don't have code access to change it. in short it is out of my scope to make change int he webservice code. how can i resolve this issue without editing any code. I can edit the web.config of webservice. but not code. please guide me.

Edited: This issue is still there. but I am getting this issue on test server only. but on production server, it is running perfectly. I want to simulate this and want to resolve it on test server. because of this i am unable to proceed for next operation which is not present on the production server. why should this arriving here (on test server).

On test server i am changing the sql server name. Because of this difference, we can conclude it should not be the issue in code. it must be issue /somewhere need setting in database side to define timeout or may be different . please guide me for the same.

---

You're gonna have to get someone who can change the code, increase the CommandTimeout (or set it to 0 for unlimited), and, more importantly, find out why the query takes so long.

---

If we set the timeout value to zero that means we are making sure that the operating will competed at any cost.