SAP Knowledge Base Article - Preview

1876283 - ERROR: ODBC call <SQLDriverConnect> for data Source <> failed:<[Microsoft][ODBC SQL Server Driver][SQLServer]login failed for user - Data Services 4.x

Symptom

  • When logging into DS Designer the following error can be seen:

ERROR: ODBC call <SQLDriverConnect> for data source<server_name>failed:<[Miscrosoft][ODBC SQL Server Driver]
[SQLServer]login failed for user ‘username'.>.Notify Customer Support. (BODI-1112172)

  • In Query Builder the SI_DB_RESERVED1 column points to the old Database Server
  • In AL_MACHINE_INFO table the new the RESERVED2 column of the RepoManager point's to the old database server
  • Deleting the repository and re-registering it in CMC does not resolve the issue


Read more...

Environment

  • SAP Data Services 4.x
  • All Supported Platforms

Product

SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2

Keywords

BODS , DS , Microsoft , db , repo, BODI 1112172, login failed, central repo, old machine name, old, hostname, blank, SI_DB_RESERVED1 , KBA , EIM-DS , Data Services , EIM-DS-SVR , Administration/Server , EIM-DS-DES , User Interface/Designer , How To

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.