How to login ASE sybase master database

[former_member636635]

I had startup the database include master database as follows:

ps -ef|grep master | grep -v grep

root 4441 1 0 01:20 ? 00:00:00 /usr/lib/postfix/master -w

sybprd 6294 6293 1 01:28 ? 00:00:26 /sybase/PRD/ASE-16_0/bin/dataserver -sPRD -d/sybase/PRD/sybsystem/master.dat -e/sybase/PRD/ASE-16_0/install/PRD.log -c/sybase/PRD/ASE-16_0/PRD.cfg -M/sybase/PRD/ASE-16_0 -i/sybase/PRD -N/sybase/PRD/ASE-16_0/sysam/PRD.properties

but I can not login mater database use isql commandfor example：sapanl /sybase/PRD% isql -Smaster -Usa -PpasswdCT-LIBRARY error: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.sapanl /sybase/PRD% isql -Smaster -Usa -Ppasswd -XCT-LIBRARY error: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.sapanl /sybase/PRD% isql -Smaster -Usapsa -Ppasswd CT-LIBRARY error: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.The error is "Requested server name not found",how can I login the master database,thank you

[Mark_A_Parsons]

For ASE specific issues a couple tags that would be more appropriate:

• SAP Adaptive Server Enterprise
• Sybase Adaptive Server Enterprise

[Mark_A_Parsons]

Items of interest:

• dataserver -sPRD => says to start the dataserver named 'PRD'
• isql -Smaster => says to log into the dataserver named 'master'

The isql invocations are providing the wrong name to the -S parameter hence the errors: "Requested server name not found"

To designate a database (to be placed in upon succesful login) you want to use the -D parameter.

Try one of the following:

isql -SPRD -Usa -Ppasswd             # upon succesful login you'll be placed in sa's default database (which is normally the 'master' database)
isql -SPRD -Usa -Ppasswd -Dmaster    # upon succesful login you'll be placed in the master database

[Johan_sapbasis]

HI,

Try this way around:

isql -Usa -S<hostname>:<port>

Still does not work check:

3206787 - Cannot connect to ASE server - SAP ASE

Kind Regards,

Johan