In our Vb.net application(userd within a local network connection inside a office), which is used from long time now some of the users get the errors only sometimes a day
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.
I have already checked following
All databases are set to autoclose OFF
Didn't find much network problems and network speed is good.
When I checked in SSMS the under server properties remote query time-out set to 600 seconds
I checked sql server log and no errors found relating to it or same error message
So what may be the reason for this error? And how to troubleshoot it?