Skip to Content
avatar image
Former Member

Sybase database backup script


We have multiple server with SAP ERP ECC 6.0 EHP 7 SP13 , where we have made script for taking backup. Backup script is working for SAP server which has sybase ASE version but same script is not working for server which has ASE version Please find the script and error message. Please help me out to resolve the issues.

Backup Script
dt=`date +"%d-%m-%Y"`
cd /dbbackup
su - sybprd -c "isql64 -Usapsa -SPRD -P$passwd -X" << EOF
dump database PRD to "/dbbackup/dbbk$dt.dmp" with compression = 101

Error message
[root@mtprod scripts]# ./
Msg 1640, Level 16, State 2:
Server 'PRD':
Adaptive Server requires encryption of the login password on the network.
Msg 4002, Level 14, State 1:
Server 'PRD':
Login failed.
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

Thanks & Regards,

Islam Shaikh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 02, 2017 at 07:45 PM

    I don't see anything obviously wrong with the script.
    The behavior, though, suggests that isql64 isn't seeing the -X parameter and so isn't sending an encrypted
    password. Perhaps passing the password through a variable is interfering somehow? I'd try moving
    the -X parameter ahead of the -P to see if that makes any difference.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2017 at 07:17 AM

    Dear Bret Halford,

    Thanks for your suggestion i have already tried that but it did not work. I am still confused and not able to resolve the issues. I forgot to mentioned OS which we are using which is Red Hat Enterprise Linux Server release 7.3 (Maipo) . I am suspecting that there may be new feature introduced in ASE version which may not allowing the script to login in to the server. Not sure !!!


    Add comment
    10|10000 characters needed characters exceeded