Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi today we are unable to login to the website.but if we restart the database hosting server.then it is working .can anyone please explain how it is happened and why it is unabled to login.and what may the reasons why it has not worked.
we just thought some hacker has tried to hack our server.is that may be one of the reasons
our website is developed in ASP.NET with c#(it is not important but just wanted to tell)
Thanks
srinivas
Posted
Updated 7-Sep-12 6:29am
v2

1 solution

One thing that might have happened is that there were too many connections to the database server. This can happen if connections are not closed properly when you're done with them in your code. Well, they're not really closed (hopefully), but rather placed back into the pool of available connections. A database server can be configured to only accept a certain number of connections, so when your connections are not recycled, new ones are attempted to be made, but will fail as the server has already reached it's limit.
Another limit that would be harder to break is the limit on handles that can exist in an OS. If this ever happens you have some serious debugging to do.

Hope this gives you some ideas!

Regards,

— Manfred
 
Share this answer
 
Comments
srinvas 7-Sep-12 12:01pm    
Thanks for ur response.actually it is never happened the website is 10yrs old and we do small modifications(maintanance project) so just today we got the problem.we thought some hacker tried to hack our server. so we just restarted and it is working fine.am i thinking in right way? is there any other reason ?
Manfred Rudolf Bihy 7-Sep-12 12:07pm    
You'll have to do some serious loggíng in your application to have some sort of information what went wrong and where. That way all you'll have to do is have a good long look at your logfiles.
BTW, "small modifications" have broken more than one thing for me in the past. If not thoroughly tested with 95 plus percent code coverage you're setting yourself up for trouble.

Cheers!
[no name] 7-Sep-12 12:30pm    
5'd not for your answer but more for your comment. :-)
fjdiewornncalwe 7-Sep-12 14:00pm    
+5. Excellent.

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