Skip to Content

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

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_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

Does anyone know how to troubleshoot this issue?


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Mar 01, 2017 at 01:27 PM

    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

    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.


    Add comment
    10|10000 characters needed characters exceeded