Solution : https://service.sap.com/sap/support/notes/1593183 (SAP Service marketplace login required)
Summary :
This SAP Note addresses connectivity issues in SQL Server environments typically manifested as dropped TCP/IP connections, with specific reference to error codes, such as 10054, in VMware setups under VMotion scenarios. Root causes are identified within the interaction between SQL Server and client networks via TCP/IP protocol configurations. Solutions provided include a detailed analysis of server settings such as enabling TCP/IP, configuring Keep Alive intervals, and adjusting client configurations through SQL Server Configuration Manager. It emphasizes understanding and managing parameters such as TcpMaxDataRetransmissions and KeepAliveInterval to enhance connectivity stability. Tools like Wireshark and accompanying guidelines are recommended for troubleshooting and analyzing intermittent connection failures.
Key words :
area sql native client configuration select client protocols, hkey_local_machine\system\currentcontrolset\services\tcpip\parameters, application sql server management studio hardcodes, area sql server network configuration->protocols, adjust sql native client configurations, tool sql server configuration manager, terms tcp/ip dropped connections, sap knowledge base article 1478133, provide problem solving guidelines, -troubleshoot-intermittent-connectivity-issues
Related Notes :
| 392892 | DBIF_RSQL_SQL_ERROR (SQL error 0 or 11) |
| 208632 | TCP/IP network protocol for MSSQL |
| 98678 | SQL Server Connection Issues |