SAP Knowledge Base Article - Preview

1478133 - How to analyze connection problems to database server

Symptom

  • SQL error 0
  • SQL error 11. Work processes in reconnect status
  • Database error 0 at FET
  • SQL error 10054 occurred; work process in reconnect
  • 10054: WSAECONNRESET: Connection reset by peer
  • Automatic Work Process Restart
  • -10054: Communication Link Failure
  • TCP Provider: An existing connection was forcibly closed by the remote host. Communication link failure
  • Operating system error 64(error not found)
  • The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication


Read more...

Environment

Valid for all MSSQL Server versions

Keywords

network connection, packet size, protocols, TCP Chimney offload, NICs, firmware, bios, LAN, VMWARE, 10054, 0, -1. , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.