Massive SQL issue shutting down our site.

Posted by Pselus on Stack Overflow See other posts from Stack Overflow or by Pselus
Published on 2010-03-23T14:34:32Z Indexed on 2010/03/23 14:53 UTC
Read the original article Hit count: 406

Filed under:

sql-handle-dbc

Our website has started timing out like crazy today. All of our clients are finding it unusable. The only error we can seem to trace down as a potential problem is this:

SQLAllocHandle on SQL_HANDLE_DBC failed Error ASP Description Error Category Microsoft OLE DB Provider for ODBC Drivers

I have no idea what it means or how to go about fixing it. Anyone ever encountered this error before?

Currently, you can log in to our site, but then once you go to do anything else, you find yourself logged out or nothing happens. We have a lot of Ajax going on so the "nothing happens" probably has to do with the Ajax pages not loading properly due to logouts and so nothing displays to the user.

Like I said, I'm at a loss. Anyone have any advice on this error?

Massive SQL issue shutting down our site.

Posted by Pselus on Server Fault See other posts from Server Fault or by Pselus
Published on 2010-03-23T14:34:32Z Indexed on 2010/03/23 18:03 UTC
Read the original article Hit count: 406

Filed under:

sql

|

sqlallochandle

|

sql-handle-dbc

Our website has started timing out like crazy today. All of our clients are finding it unusable. The only error we can seem to trace down as a potential problem is this:

SQLAllocHandle on SQL_HANDLE_DBC failed Error ASP Description Error Category Microsoft OLE DB Provider for ODBC Drivers

I have no idea what it means or how to go about fixing it. Anyone ever encountered this error before?

Currently, you can log in to our site, but then once you go to do anything else, you find yourself logged out or nothing happens. We have a lot of Ajax going on so the "nothing happens" probably has to do with the Ajax pages not loading properly due to logouts and so nothing displays to the user.

Like I said, I'm at a loss. Anyone have any advice on this error?

EDIT

I realize that this isn't necessarily a programming question, but we are a small startup company that just yesterday started talking about how we need to get a backup server running. Apparently we talked about it too late. We don't have a DBA, just 2 mid level programmers trying their hardest to keep our clients happy. So please, if you have any assistance give it but please don't close my question right now.

EDIT 2

Turns out we had something on our server running called "ServerMask" that makes our IIS server look like Apache to the outside world. Shutting it down fixed our issue. Still no idea why it was messing up but it was the problem apparently.

Thanks to everyone who tried to help.

Developer IT