3
Answers

SqlException: Execution Timeout Expired. The timeout period

 
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"
Answers (3)
0
Saravanan Ponnusamy

Saravanan Ponnusamy

NA 1.3k 59.1k 7y
check you entered correct credentials in connection string
 
Data Source=sqlenginename;Network Library=DBMSSOCN;Initial Catalog=databasename;User ID=loginID;Password=password
 
0
Megna Musapeta

Megna Musapeta

NA 49 2k 7y
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 Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 7y
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.