Discussion Locked

ADO.NET App Stops Trying To Reach SQL DB

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have an ASP.NET app on our internet server (IIS 6) that displays data (company news headlines, etc) from a SQL Server behind our firewall, using the SQLClient objects.

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?

1 reply

by 3xp3rt

Verify the connection string. If this is OK, verify the connection properties. Set this to reconnect after disconnect, and verify also the connection timeout.

This discussion is closed to new replies.