Timeout expired problem, thanks
I have a problem with my application connecting to sql server
Here's the description.
At first login attempt, when its the first time I try to connect to sqlserver.
When I try to log into the app I am currently working on for the first time I get the following error:
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding."
However when I try to login a second time , the login is successfull.
Please anyone knows how I can solve this problem. I have tried increasing timeout from sqlserver, but it didnt work. I have also tried to increase the command timeout in web config shown below but it still didnt work. i'd appreciate any solutions, thanks.
<membership defaultProvider="IAccountantSqlMembershipProvider" >
<!-- Add a customized SqlMembershipProvider -->
<add name="IAccountantSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="IAccountantDBConnectionStrin g" enablePasswordRetrieval="false" enablePasswordReset="true" commandTimeout="9600" requiresQuestionAndAnswer="false" applicationName="iAccountant" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="10" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="20" passwordStrengthRegularExpression=""/>