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
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.