Unable to login into WebSite

Question

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.

Thanks,

Suresh

Posted 7-Sep-12 12:43pm

Member 4391175

Updated 7-Sep-12 13:12pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 7-Sep-12 19:58pm

Not enough information.
--SA

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

Thanks

bbirajdar 14-Sep-12 2:17am

Did you debug the code?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

vithal wadje · Answer 1 · 2012-09-13T20:16:00

Solution 1

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

Posted 13-Sep-12 20:16pm

vithal wadje