Increase value for Timeout of your SQL Connection & SQL Command
For Connection in Web.Config,
<add key="ConnectionString" value="server=(local); uid=sa; password=sa; database=master;Connection Timeout=30" />
For Command,
public void CreateSqlCommand()
{
SqlCommand cmd = new SqlCommand();
cmd.CommandTimeout = 15;
cmd.CommandType = CommandType.Text;
}
& also take a look at the following page.
Troubleshooting: Timeout expired[
^]
Free attachment
DBA’s Quick Guide to Timeouts[
^]