SAP Knowledge Base Article - Preview

2952753 - SQL Server error: Login failed for user - SAP Data Services 4.2

Symptom

When running Data Services job you receive the following error:

  • in monitor log:
    • @CON-120302, ERROR, 0, 0.000, 1.692, 0.000, 0.000, 0:0, 0.000, 0, CON-120302: |Session job_name: ODBC call <SQLDriverConnect> for data source <server_name> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'database_user'.>. Notify Customer Support.
  • in error log:
    • ODBC call <SQLDriverConnect> for data source <server_name> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
      for user 'database_user'.>. Notify Customer Support.


Read more...

Environment

  • SAP Data Services 4.2
  • All supported versions of Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

RUN-305004 , CON-120302 , CON-120307 , KBA , EIM-DS-DES , User Interface/Designer , 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.