SAP Knowledge Base Article - Preview

3658397 - R3trans -d fails with Database Connectivity Issues to SQL Server Database Intermittently - NetWeaver

Symptom

  • R3trans -d fails Intermittently
  • Trans.log shows error:

    ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
    [Microsoft][ODBC Driver 18 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [64]. 
    ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
    [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired
    ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
    [Microsoft][ODBC Driver 18 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to <hostname>. 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.
    Connection 0 failed using Driver={ODBC Driver 18 for SQL Server};Server=<hostname>;AutoTranslate=no;Trusted_Connection=yes;WSID=<id>;APP=R3 00 comm rd ODBC;Database=<SID>;Encrypt=optional;
    LOG BY2=>sql error 99     performing CON
    LOG BY0=>Login timeout expired


Read more...

Environment

  • SQL Server AlwaysOn

Keywords

java instance startup failure, os/db upgrade, iaik_jce.jar, corrupted file, sap erp, config tool error, fatal error, java instance not starting, sap java issue, java instance troubleshooting, sap startup failure, sap erp java startup. , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.