SAP Knowledge Base Article - Preview

1986730 - Scheduled Job is not connecting to Repo

Symptom

  • Local Repository database is Microsoft SQL Server named instance
  • Data Services Batch Job scheduled using Data Services scheduler and use password file is unchecked.
  • Schedule fires as can be seen in job launcher logs and server event logs but jobs log indicate the engine was not able to connect to repository and shows error similar to the following:

ODBC call <SQLDriverConnect> for data source <server name> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "<repo name>" requested by the login. The login failed.>. Notify Customer Support.

 


Read more...

Environment

  • SAP Data Services 4.1 SP3
  • SAP Data Services 4.2
  • Microsoft SQL Server - named instance as repository database

Product

SAP Data Services 4.1 ; SAP Data Services 4.2

Keywords

named instance ds schedule error , KBA , 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.