Skip to Content
0

Issue while connecting to SQL Anywhere database (SAP BO)

Apr 10 at 03:22 PM

41

avatar image

Hi All,

Hope you are doing well !

We have BO 4.2 SP5 and SQL Anywhere 17 as CMS database.

We have got CMS database parameters from Regedit i.e. database name, server name, DSN name, User name and password.

We are using same parameters to client tool in SQL anywhere but we are not able to connect to the database. It is throwing the error user and password is incorrect.

As per our understanding, If user name and password for CMS is incorrect then BO should not work but is running seamlessly.

Please provide you valuable suggestion to resolve the issue.

10 |10000 characters needed characters left characters exceeded

You cannot get password from registry.
You need to talk to your DBA.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sonet Kebede
Apr 10 at 04:43 PM
0

Did you install this product? Are you unable to access the CMS or DSN or IDT?

Can you please clarify your workflow?

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Apr 10 at 04:51 PM
0

The password you found in the registry is encrypted, so it's not going to work to log in. The BOBJ configuration in the CCM knows what the correct password is, which is why it's running correctly.

SAP Note 2063532 will give you the information you need to reset the password for the "dba" account in SQL Anywhere. If you change it, you'll probably also have to change it in the CCM.

-Dell

Share
10 |10000 characters needed characters left characters exceeded