SAP BODS data store connection is not working in one local repo

[former_member595184]

Hi,

We are using BODS 4.2 and have multiple local repository which are using common data store connections. Suddenly data store connection for one of the bods SQL SERVER database in local one repo is not working. It is working for all other repos and apparently nobody knows this password for this specific data store connections. I am getting below message while viewing the data in the datastore in BODS :

ODBC call <SQLDriverConnect> for data source <XXXXXXX> failed: <[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'XXXXXXX'.>. Notify Customer Support.

Can you guys help how can I fix this ODBC error in that particular repo. Thanks.

[former_member466847]

Hello the error message states a login error.
Has the user name password changed for that connection?

Is the error when signing into Designer against that repository or when connecting to the datastore inside Designer.

Does the error occur in CMS, Repository Manager, or when accessing the database?

Were these repositories or databases moved from a different server?
https://launchpad.support.sap.com/#/notes/1876283

Are the Dataservices client and job server the same version?

https://launchpad.support.sap.com/#/notes/1864296

[former_member595184]

Hi Jessica,

Thank you for your reply, here are my responses:

Has the user name password changed for that connection? ----> No , This is working fine for other local repositories, only broken in one repo.

Is the error when signing into Designer against that repository or when connecting to the datastore inside Designer. ---> Error is coming when connecting to datastore inside designer

Does the error occur in CMS, Repository Manager, or when accessing the database? ----> When accessing the database, when I try to execute any job which is using template tables from this datastore in data services designer then this error comes or when try to view data in datastore connection for any of the table

Were these repositories or databases moved from a different server? -----> No, This was working fine till last week, suddenly it stopped working
https://launchpad.support.sap.com/#/notes/1876283

Are the Dataservices client and job server the same version? -----> No, They are both same versions( 14.2.2.446)

https://launchpad.support.sap.com/#/notes/1864296