General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
ADO.NET Web App Stops Trying To Reach SQL Database
Several times now we've had a situation where the SQL Server became unavailable for a length of time, once when we upgraded hardware, and again last weekend when power to the whole building was down for 18 hours. Even after the SQL box came back up, the headlines did not show up, and setting it to display the error told us it was getting "SQL Server not found or access denied" errors. We still have older, regular ASP pages on this same IIS server that also access the same SQL Server, and they were getting their data with no problems. We tried restarting the IIS server, but it did not resolve the problem. The solution was to reboot the internet server box.
So, why did the .NET app give up trying to reach the SQL box? Is there something else we can reset, other than rebooting the IIS server?