We are running separate Pharos and Db servers and have encountered loss of connection problems when restarting the Db server following service patch installs. We are wondering what business process others are using to maintain this connection. The service is set to restart on fail, but with offline billing enabled, the system simply stops attempting to make a connection to the Db server. Once the Db server is back online the service has to be manually started/restarted.
Has anyone encountered this issue, and if so, how are you handling the connectivity between the systems? This shouldn't be an issue if the the Db server is running under the same OS instance.
Thanks for any help!