how to solve The wait operation timed out Error

Question

Any One Can help me to solve The wait operation timed out Error In Mvc. when i run my application in local server it work fine ....but after deploy of Project in Server i am getting this Error ... In my Local DataBase and Server database have same entry. plz tell me how to slove.. My WebSite link is http://www.shopindeal.com/

Dr.Ajay Kashyap · Answer

@Prabhu E 1. your first solution >> 1. If your SP having JOIN Queries without NOLOCK. Please feel free to use with (NOLOCK). >> but i am not using sp your second solution>> If you already included CommandTimeout in DB call. Please increase it. >> but when data is increase in tables then what to do always increasing the CommandTimeout ??? Third solution >> i already increased the time 120 seconds to 240 seconds but it is not solved yet so please tell me what is the problem of timeout error and solution Thanks in advance

Amit Gupta · Answer

The network related issue is with the improper connection string. Do check the server name, database, id or password.

Prabu Elavarasan · Answer

Hello, Try to do the below steps. Hope this will help you. 1. If your SP having JOIN Queries without NOLOCK. Please feel free to use with (NOLOCK). 2. If you already included CommandTimeout in DB call. Please increase it. 3. If the above two methods not helped means, try to increase the timeout at IIS level.

Ankit Sharma · Answer

hi, Please make sure that your SQL server is accesible by the application. Also check if you application pool is running or not. https://stackoverflow.com/questions/36909490/the-wait-operation-timed-out https://forums.asp.net/t/2017100.aspx?The+wait+operation+timed+out+in+SQL+Server Hope this helps