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 ONE Support launchpad (Login required).

Search for additional results

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