SAP Knowledge Base Article - Preview

3700942 - A network-related or instance-specific error has occurred while establishing a connection to SQL Server.

Symptom

Your SAP NetWeaver (SAP ERP) system does not start up.

  • The SAP application server Work Processes developer trace indicate following message:

-----------------------------------------------------------------------------------------------------------------

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
C  (99) [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
C  (10061) [08001] [Microsoft] [ODBC Driver 17 for SQL Server] A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

-----------------------------------------------------------------------------------------------------------------

  • R3trans -d command returns following message:

-----------------------------------------------------------------------------------------------------------------

This is R3trans version x.xx (release 7xx - dd-mm.yy).
unicode enabled version
2EETW169 no connect possible: "DBMS = MSSQL                                    ---  SERVER = 'hostname'  DBNAME = 'SID'"
R3trans finished (0012).

-----------------------------------------------------------------------------------------------------------------


Read more...

Environment

SAP NetWeaver on Microsoft Windows Server/SQL Server 'Enterprise Edition'

Keywords

Hosts file, ODBC driver, SNAC, 10054, 10061, environment variables, default instance, named instance, firewall, TCP Provider, An existing connection was forcibly closed by the remote host, Unable to open a logical session, TCP/IP network protocol, named pipes, Local shared memory (LPC), port , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem

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.