SQL Timeout

Errors and Error Messages
Q: I receive the following error after logging into EP, and a long wait for the screen to change:
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

A:
Please try to make the following modifications in your Web.Config file (it's in the EP root folder - using Notepad, only).


----before the modification----
   

<sessionPageState historySize="99" />
    <sessionState mode="SQLServer" sqlConnectionString="server=yourserver;Trusted_Connection=false;uid=youruser;pwd=yourpass;enlist=false;" />



----after the modification----

   

<sessionPageState historySize="20" />
    <sessionState mode="SQLServer" sqlConnectionString="server=yourserver;Trusted_Connection=false;uid=youruser;pwd=yourpass;enlist=false;" timeout="600" />




where yourserver - SQL server name, youruser - SQL server user name, yourpass - SQL server user password.