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.