Adaptive Server requires encryption of the login password on the network

[Former Member]

Hi experts,

I have installed a distributed configuration of BO BI 4.1 SP5 on Linux RH 6.5 with Sybase ASE 15.7 SP 131 :

SAP ASE 15.7 SP131 on one server & CMS on an other server.

Everything works well.

Now, I would like to activate "net password encryption reqd" on my Sybase server.

But when this parameter is activated, CMS server doesn't start anymore :

more error_boe_cmsd6400.log

33007   SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""<SID>"". Reason: Adaptive Server requires encryption of

the login password on the network.

35101   The root server reported an error Initialization Failure. (Reason: SAP BusinessObjects BI platform CMS: Unable to connect to the CMS syst

em database ""<SID>"". Reason: Adaptive Server requires encryption of the login password on the network. SAP BusinessObjects BI platform CMS: Unabl

e to connect to the CMS system database ""<SID>"". Reason: Adaptive Server requires encryption of the login password on the network.  CDatabase::Op

en failure. ).

Can someone help me?

What kind of connection mechanism is used by CMS server to access CMS DB Repository?

Regards

[Unicorn_LM]

Hi,

This is a known issue.

There is a solution in sap note 2273134.

Regards.

[former_member207908]

Dear Chris,

Send the output of sp_configure "password"

Specify the "-X" flag when using isql.

The client password encription is required to be used (ASE configuration parameter "net password encryption reqd" should has a value > 0 ).

HTH

Rajesh

[Former Member]

Hi,

thanks for your answer.

I know that password encryption is required, that's why I would like to activate it on my BO BI4.1 environment.

My problem comes from this parameter.

When not set, CMS can start and connect to SAP ASE CMS Repository

When this parameter is set, CMS doesn't start anymore with error message :

more error_boe_cmsd6400.log

33007   SAP BusinessObjects BI platform CMS: Unable to connect to the CMS system database ""<SID>"". Reason: Adaptive Server requires encryption of

the login password on the network.

35101   The root server reported an error Initialization Failure. (Reason: SAP BusinessObjects BI platform CMS: Unable to connect to the CMS syst

em database ""<SID>"". Reason: Adaptive Server requires encryption of the login password on the network. SAP BusinessObjects BI platform CMS: Unabl

e to connect to the CMS system database ""<SID>"". Reason: Adaptive Server requires encryption of the login password on the network.  CDatabase::Op

en failure. ).

So, how to make CMS use password encryption to connect to SAP ASE CMS Repository?

Regards

[Former Member]

hi Chris,

  I am having the same issue. Have you found a solution?

regards,

Anne