we are facing some issue on quality server. We have connected remote SQL database. But sometimes getting error
"FATAL SQL error occurred on connection [remote server name], code 0, state='08S01' message='Connection reset by peer, socket write error"
and due to this connection get lost between MII and remote database. We need to restart application resource every time to work it again. after restarting it works properly.
I think its issue with net packet size and default packet size of remote database. may be network_packet_size is greater than default_packet_size?? Is that the reason?? If yes how to change that setting?
Please help me. Thanks in advance.