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_member595184]

Hi Jessica- I was able to export this data store from another local repo to My repo and now this error is resolved and the data store connection is working fine. Thank you for your help and answers. I appreciate it.

Regards,
Ruchika