I have an application that runs 24/7 and is connected to an sql database (sql server).
However, the application crashes most night with the following error message
*An existing connection was forcibly closed by the remote host. *
the db resides on a different server than the application, so I first suspected a network connectivity issue that happened at night.
I ran a script overnight, to ping the db server every 5 minutes and tell me if there were such network connectivity loss, but over the course of 1 week, I only had 1 failed ping.
My next guess is that there could be a database connectivity issue, but i am not sure how I can automate a similar test on the database connection itself (I do not have access to the database server).
I created a UDL file, to test my connection manually (and that works fine), but I would like to such a test to run every 5 minutes overnight, and let me know in a log file, if and when the connection may have failed.
Thanks for your help!
ran script to test network connectivity overnight between appl and db server.
Network connection seems good 24/7 between the application and the db server.
I would now like to run a similar test at 1 or 5 minutes internals on the db connection itself, but I am unaware of how to do that.
I can test manually with a udl file, but I need to help to automate the test and output results in a log file.
Thanks
