Solved: ISQL error on Sybase (Solman 7.1)

Former Member · ‎2013 Nov 27

I have installed SAP Solman 7.1 on the Sybase DB , When i first time try to login to Sybase DB with SAPSA user , i am getting below error.

Msg 1640, Level 16, State 2:

Server 'SID':

Adaptive Server requires encryption of the login password on the network.

Msg 4002, Level 14, State 1:

Server 'SID':

Login failed.

CT-LIBRARY error:

ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed

Please can you help , it is very urgent issue to be solved..

Thanks

Prasanna

sunny_pahuja2 · ‎2013 Nov 27

Hello,

Please refer to SAP 1942379 - Setup password encryption to encrypt login passwords on the network between ASE and isql to resolve this issue.

Thanks,

Sunny

Former Member · ‎2014 Feb 08

Hi hugo delgado,

If you are facing a similar error, please follow the given procedure:

1.

isql -Usa -S<SID> -X
Password:

"-X" will bypass your encryption.

2.

after you have logged in

change the "net password encryption reqd" parameter

>sp_configure 'net password encryption reqd',2

>go

thanks

Amarnath

ISQL error on Sybase (Solman 7.1)