SAP Knowledge Base Article - Preview

3003223 - BW data extraction fails due to the remote SQL Server connection is not stable- NetWeaver

Symptom

• BW data extraction fails time to time

• The DBCO connection from BW system to remote SQL Server is not stable

• Following error message shows in developer trace file(dev_w*):

==========================

C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3233]
C  (-1) [08001] [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [x
C  1 times error (0,0) or (-1,0) in sequence
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3233]
C  (99) [HYT00] [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3233]
C  (-1) [08001] [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishi
C  Connection 0 failed using Driver={ODBC Driver 13 for SQL Server};Server=hostname;AutoTranslate=no;UID=APOSourceSystem;
C
B  ***LOG BY2=> sql error -1 performing CON [dbds         989]
B  ***LOG BY0=> SQL Server Network Interfaces: Error Locating Server/Instance

==========================


Read more...

Environment

• SAP Systems based on SAP NetWeaver

• Microsoft SQL Server 2005 and higher

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP Supply Chain Management 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

tcp/ip,MSSQL_SERVER,DBCO,sql error -1,Login timeout expired , 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.