SAP Knowledge Base Article - Preview

1670879 - Batch job fails to load to SQL Server with timeout error - Data Services

Symptom

  • Data Services batch job fails to load to SQL Server.
  • Data Services batch job fails with error [Microsoft][ODBC SQL Server Driver]Timeout expired
  • Error:  Login timeout expired
  • Error:  CON-120302: ODBC call <SQLDriverConnect> for data source <datasourcename> failed: <[Microsoft][SQL Server Native Client 11.0]TCP Provider:  Timeout error [258]. [Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in login response [Microsoft][SQL Server Native Client 11.0]Login timeout expired>. Notify Customer Support.
  • Error: TCP Provider: An existing connection was forcibly closed by the remote host.
  • Error: ODBC SQL Server Driver Timeout expired


Read more...

Environment

  • SAP Data Services
  • Microsoft SQL Server

Product

SAP Data Services all versions

Keywords

BODS, BODI , KBA , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , 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.