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 · Accepted solution]

hello Ruchika,
The error is coming from the Database ODBC driver. either the password is incorrect or not in an accepted format for that driver. like special characters in the string.

The connection string is made up of different attributes that part of the user authentication is added to before being sent to the database.
A list of known attributes are listed below.

https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-connectio...

You can also set the connection string at the ODBC Administrator configuration.
https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-an-odbc-data...

Can you please confirm that the ODBC Administrator instance for the driver is correct? Please work with your DBA for the database configuration

[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

[former_member466847]

Thank you for the update, it is possible to make a new test Database Datastore to this same account and see if the issue continues with a test job. it is possible the connection string is becoming invalid inside Designer.

Please know that 14.2.2.446 is no longer patch fixable nor has escalation support. So if you make a ticket you may be requested to recreated this error in a higher version of Data Services.

[former_member595184]

Hi Jessica- I updated the password in data store connection and the login error is gone and now I am seeing this new error :

ODBC call <SQLDriverConnect> for data source <XXXXXXX> failed: <[Microsoft][SQL Server Native Client 11.0]Invalid value specified for connection string attribute 'PWD'>. Notify Customer Support.

Do you have any thoughts how can I fix this? What is connection string attribute?

[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