Unable to login to ISQL with encryption option: CT-LIBRARY error: ct_connect()

[former_member235282]

Dear SAP experts

After upgrading an ASE database 15.7.132 to 15.7.138 and when I try to open ISQL using -X parameter I am facing this error

C:\Users\hsdadm>isql -Usapsa -P123456 -SHSD -X

CT-LIBRARY error:
ct_connect(): protocol specific layer: internal Client Library error: Th ere is a tds login error. The installed encryption handler returned a status tha t was not CS_SUCCEED.

If I try only with isql -Usapsa -P123456 -SHSD it works fine. The error is causing problems with an external tool (data protector) that I use to backup the database.

I have set sp_configure 'net password encryption reqd' with 0,1, 2 and 3 and the issue continues.

It happens with sybadm and sidadm users.

My system scenario is:
Application: SOLMAN 7.1
Database: Sybase ASE 15.7.138
Single installation
Windows2012R2

Does anyone know how to troubleshoot this issue?

Regards
DanielO

[former_member235282 · Accepted solution]

To whom It May Concern:

I solved the issue. I will explain how I've done.

1. I have installed 2-bit Microsoft Visual C++ 2005 Service Pack 1.
2. I have set a new environment variable:

LIBPATH = \sybase\HSD\OCS-15_0\lib;\sybase\HSD\OCS-15_0\lib3p;\sybase\HSD\OCS-15_0\lib3p64. I've followed this thread http://nntp-archive.sybase.com/nntp-archive/action/article/%3C4f448dda@forums-1-dub%3E

This new environment variable was set for <sybsid> and <sidadm> users.

3. I've set the parameter sp_configure 'net password encryption reqd',2

It worked for me, I hope for you too.

Regards,
DanielO