Skip to Content
0

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

Feb 21, 2017 at 02:59 PM

84

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
DANIEL OSPINA GARCIA Mar 01, 2017 at 01:27 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded