SqlException: Execution Timeout Expired. The timeout period

Megna Musapeta

9y3.5k

I Created a WebGrid using MVC but when i try to run I am getting this Error Message "SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.", I Checked SQL Server Logs but it is not even Connecting the Database, It is timing out after 1 minute, I Included these Timeouts but it is not working, Please help.

binding name="basicHttpBinding"

closeTimeout="00:10:00" openTimeout="00:10:00" receiveTimeout="00:10:00"

sendTimeout="00:10:00"

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saravanan Ponnusamy9y ago
check you entered correct credentials in connection string

Data Source=sqlenginename;Network Library=DBMSSOCN;Initial Catalog=databasename;User ID=loginID;Password=password
0
Megna Musapeta9y ago
SQL Server Database Name is Correct.
SQL Server is Up & Running.
Credentials are Correct too.
It is taking 1 minute 30 Seconds to run the Stored Procedure.
0
Manas Mohapatra9y ago
To resolve your issue:

Make sure that you are providing correct credentials and Sqlserver process is running mode.
Secondly, make sure that you provided correct database as well.
Thridly, check how much time it is taking in SQlServer to execute the same query.
0