Frequent user disconnects and the following error in the server log:
2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error: DBErrorType = 'dbConnection' Native SQL Code = -1 ODBC sqlstate = 08S02 ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]SMux Provider: Physical connection is not usable [xFFFFFFFF]. ' 2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error: DBErrorType = 'dbConnection' Native SQL Code = -1 ODBC sqlstate = 08S02 ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]Unable to open a logical session' 2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(2921) : Failed Assert: Database Statement Error: DBErrorType = 'dbStatement' Native SQL Code = 0 ODBC sqlstate = S1010 ODBC errortext = '[Microsoft][ODBC Driver Manager] Function sequence error'
2017-04-07 07:42:47.0808 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error: DBErrorType = 'dbConnection' Native SQL Code = 0 ODBC sqlstate = 08S01 ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]Communication link failure'
Recommended by Amazon Team that disable the TCP Chimney Offload
Disable the below settings in Local network connection à Network adapter properties.
And also disable below settings from Command prompt:
https://support.microsoft.com/en-ca/help/951037/information-about-the-tcp-chimney-offload-receive-side-scaling-and-net