Click here to Skip to main content
15,749,352 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
It is an 8 years project.I am working on this project since 1 year.ther is a stored procedure to verifiy user login credentials.If every thing is correct then user is logined to that website.

I didn't get any problem till now, from last 2 days i am getting some problems. Users are unable to login into my website.They are entering user name and password and clicking login button, after clicking the login button it saying user and password is incorrect.

But every users is getting same problem.

When i open the log file , in the log file there is exception i.e get_login_user is an stored procedure (skg is username and password is s12@23)

[09-07-2012 09:19:28:094] get_login_user 'skg', 's12@23'
[09-07-2012 09:19:28:172] ExceptionSystem.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

If i restart the Database Server, then they are able login into website.

I am unable to find the problem.

Please help me.


Updated 7-Sep-12 13:12pm
Sergey Alexandrovich Kryukov 7-Sep-12 19:58pm    
Not enough information.
deepakaitr12345 8-Sep-12 4:30am    
This is the very common problem.
if you don't close the connection properly,or do not disposing the reader.
this kind of problem occured.
Please check these 2 things firest

then check it out
whether your log4net getting the database or not.

Hope it will help you

bbirajdar 14-Sep-12 2:17am    
Did you debug the code?

1 solution

This is common problem. Increase your database connection Timeout Time..Means I think problem is happening because of less database connection TimeOut
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900