I have a .NET application that connects from A Windows 10 client to an SQL Server 2016 Express database running on Windows Server 2012 R2. Whilst a connection is successfully established, it is frequently throwing the following error on subsequent connection attempts:
"The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts."
I have researched this and have not been able to get to the bottom of why this is suddenly occurring after the system has been stable for months.