Hi there, I have 2 servers, web and SQL server. Both running in Windows 2003 server with IIS6 and MSSQL 2000 installed respectively. Basically the web server runs ASP codes and connects to the SQL server. All the updates are installed and everything runs fine for years.
Problem starts happening today, with all the pages cannot be shown (not only .asp pages but also .html pages, and even gif and jpg image files, as weird as you can imagine) giving varies errors. When I restart IIS or even rebooting both servers, the pages run fine for a while, and the same errors start coming out within 5 minutes. The error message coming out most of the time is shown as below:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_DBC failed"
... or just simple "HTTP/1.1 500 Server Error"...
I've tried reinstalling IIS, even uninstall all the .NET frameworks and install the newest .NET framework 4.0, but no miracle happens.
Obviously a nightmare for me and everybody in the office is screaming at me, as expected....