ISQL login error SYBASE

[Former Member]

Hi Guys,

We recently installed SAP NW7.3 Ehp1 on Windows 2008 server with Sybase database version 15.7,installation was successful without any error's,when I try to login to database its throw error

I logged in as SIDADm and exeuted below command and end up with below error,

D:\sybase\SBP\OCS-15_0\bin>isql

Password:

CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer

error: Requested server name not found.

Could any one help me out with how this can be fixed?

Regards

Uday

[Former Member]

with witch user you are loged on?

To run isql command use syb<sid> user.

Please check the environment of the users:

LIB=<Win-drive>:\sybase\SID\OCS-15_0\lib;

PATH=<Win-drive>:\sybase\<SID>\ASE-15_0\jobscheduler\bin;<Win-drive>:\sybase\<SID>\ASE-15_0\dll;<Win-drive>:\sybase\<SID>\ASE-15_0\bin;<Win-drive>:\sybase\<SID>\DBISQL\bin;<Win-drive>:\sybase\<SID>\OCS-15_0\lib3p64;<Win-drive>:\sybase\<SID>\OCS-15_0\lib3p;<Win-drive>:\sybase\<SID>\OCS-15_0\dll;<Win-drive>:\sybase\<SID>\OCS-15_0\bin

SYBASE=<Win-drive>:\sybase\<SID>

SYBASE_ASE=ASE-15_0

Regards Arne

[Former Member]

Hi,

I have two users created at OS level
<SID>adm and syb<SID>

I logged in with <SID>adm and below are the env set in user environment,nothing is maintained in system variable

DBMS_TYPE = syb
dbs_syb_dbname = SBP
dbs_syb_port = 4901
dbs_syb_schema = SAPSR3
dbs_syb_server = EASINDEMO2
INCLUDE D:\sybase\SBP\OCS-15_0\include
LIB = D:\sybase\SBP\OCS-15_0\lib
PATH = D:\sybase\SBP\ASE-15_0\jobscheduler\bin
rsdb_ssfs_connect = 1
RSEC_SSFS_DATAPATH = \\EASINDEMO2\sapmnt\SBP\SYS\global\security\rsecssfs\data
RSEC_SSFS_KEYPATH = \\EASINDEMO2\sapmnt\SBP\SYS\global\security\rsecssfs\key
SAPEXE = D:\usr\sap\SBP\SYS\exe\uc\NTAMD64
SAPLOCALHOST = EASINDEMO2
SAPSYSTEMNAME = SBP
SCROOT = D:\sybase\SBP\Shared\Sybase Central 6.0.0
SYBASE = D:\sybase\SBP
SYBASE_ASE = ASE-15_0
SYBASE_JRE_RTDS = D:\sybase\SBP\Shared\JRE-6_0_24_64BIT
SYBASE_JRE6 = D:\sybase\SBP\Shared\JRE-6_0_24_64BIT
SYBASE_JRE6_32 = D:\sybase\SBP\Shared\JRE-6_0_24_32BIT
SYBASE_JRE6_64 = D:\sybase\SBP\Shared\JRE-6_0_24_64BIT
SYBASE_OCS = OCS-15_0
SYBASE_WS = WS-15_0
SYBROOT = D:\sybase\SBP
TEMP = D:\usr\sap\SBP\tmp

Below is the output of the command

D:\sybase\SBP\OCS-15_0\bin>isql -Usa -S SBP
Password:
Msg 4002, Level 14, State 1:
Server 'SBP':
Login failed.
CT-LIBRARY error:
        ct_connect(): protocol specific layer: external error: The attempt to co
nnect to the server failed

[Former Member]

Good news - you've got an error back from ASE so everything is working  - well apart from your username/password combination!

Do you know what the sa account as set to during installation?  Or what other accounts where setup during installation?

[Former Member]

Now I logged in as syb<SID) and executed below command;

C:\Users\sybsbp>isql -Usa -S SBP
Password:
Msg 4002, Level 14, State 1:
Server 'SBP':
Login failed.
CT-LIBRARY error:
        ct_connect(): protocol specific layer: external error: The attempt to co
nnect to the server failed.

D:\sybase\SBP>isql
Password:
Msg 4002, Level 14, State 1:
Server 'SBP':
Login failed.
CT-LIBRARY error:
        ct_connect(): protocol specific layer: external error: The attempt to co
nnect to the server failed.

Below are the variable set for that user,

LIB = D:\sybase\SBP\OCS-15_0\lib;

D:\sybase\SBP\ASE-15_0\jobscheduler\bin;D:\sybase\SBP\ASE-15_0\dll;D:\sybase\SBP\ASE-15_0\bin;D:\sybase\SBP\DBISQL\bin;D:\sybase\SBP\OCS-15_0\lib3p64;D:\sybase\SBP\OCS-15_0\lib3p;D:\sybase\SBP\OCS-15_0\dll;D:\sybase\SBP\OCS-15_0\bin

SYBASE = D:\sybase\SBP
SYBASE_ASE = ASE-15_0

[Former Member]

I guess that the sa user is locked. Can you try to connect with another user?

Try to unlock the sa user:

$> isql -Usapsso -S<SID>

                       1> sp_locklogin 'sa', 'unlock'

                       2> go

by default the sa user is locked, if you want to connect with you have to unlock.

Regards

Arne

[Former Member]

Hi

I unlocked the sa user with below command as you said,

D:\sybase\SBP>isql -Usapsso -SSBP
Password:
1> sp_locklogin 'sa', 'unlock'
2> go
Account unlocked.
(return status = 0)
1>

What next?

[JanStallkamp]

Hi.

You just have logged in as user sapsso, so you can use isql. As you have unlocked sa you can now log in as the sa user. But in general we recommend to keep the sa user locked and only unlock it if this is really required.

There is a user sapsa which can be used for administrative work in isql.

Regards,

Jan

[Former Member]

now you can connect with the sa user which was your initial attempt

isql -Usa -S SBP

then do whatever you want to do with sa user

Regards

Arne

[Former Member]

Thanks Arne/Chris/Jan

I was able to logging now,what I have learned now is

We need to as syb<SID> user and connect to sybase database with sapsa (Database Administartor user) to perform out tasks

I have one more question

Do we have any graphic mode or url where we can perform the same set of things what we do from command prompt?

At last what is the way to assign point to every one who gave me valuable suggested to solve my problems

Regards

Uday

[former_member197516]

Yes - the GUI version of ISQL is called Sybase Central. 

There are also some third-party products out there as well but I use Sybase Central  (its from SAP Sybase).

[Former Member]

Go to <unit where Sybase is installled>\sybase\<SID>\Shared\Sybase Central 6.0.0. There you will find an EXE java based, that you can use as your gui to Sybase.

BR

Fred

[ryan_hansen]

Hi,

Sybase Central is EOL.

I would download this soon if you would like to use this tool.

The tool taking over for Sybase Central is called Sybase Control Center (SCC).

If you want an interactive/gui isql session the tool is called DBISQL or also known as Interactive SQL.

This comes in the Sybase Central download (PC Client).

This can be also be accessed through Sybase Central tool itself.

In future releases DBISQL will be included in the SDK download.

Regards,

Ryan

[Former Member]

Hi Arne

What are the passwords for the users sapss and sapsso please? Getting that same problem of a new installation and cannot connect to the adaptive server. Please assist.

Regards

Rob

[victoria_normand]

Hi,
Just for information, on SAP BS/BW environment recommendation is to use the DBACockpit (t-code DB02 or dbacockpit) instead of Sybase Control Center. SQL code can also ben run from dbacockpit.

Also to keep in mind that on SAP BS/BW environments we will always need to specify the "-X" flag when using isql. The client password encription is required to be used (ASE configuration parameter "net password encryption reqd" should has a value > 0 ).
Best regards,
Victoria Normand.

[victoria_normand]

Hi Rob,

There is not default password for sapsa and sapsso. You may reset them following Correct Answer from thread "Reset sapsa password" http://scn.sap.com/message/15488510#15488510.

Best regards,
Victoria.

[former_member409033]

Dear Arne,

Thank you so much.....

I have the same query and your answer is helpful for me.

Thanks & Regards,

Mahip

[caos01]

Once set environment variables can you try

isql -Usapsa -S<SDIS> -Pxxxxxxxx -X

[amitkumar01]

Hi Uday,

Kindly check the following:

1) Whether the server is Up or not.

2) If up then check whether Environment variable is set or not.

3) Check the interfaces file for the server. See if it entry is there.

Hope this helps.

Thanks & Regards,

Amit kumar Singh

Message was edited by: AMIT KUMAR SINGH

[Former Member]

To anyone who is still looking for a solution and cant find it,

if you add a sybase user and system,

ex: isql -Usa -P<pass> -S<SID> -X (and this system logs on to isql)

1>

2>

(and you get this error when you create an instnace)

iqsl -U<created user> -P<pass> -S<created instance> - X

ct-library error...

incortporate them in your interface files.

/SYBASE/<SID>/interfaces

and make sure the port number is the same as the original <SID> instance.

<SID>

master tcp ether <localhost> *port

query tcp ether <localhost> *port

<new instance>

master tcp ether <localhost> *same port as above.

query tcp ether <localhost> *same port as above

hope that helps.

Federico Peric.

[crisnormand]

Hello Federico,

This thread is now quite old and the initial question was already answered, even if unfortunately no correct answer was marked.

Basically the problem was because

1) SYBASE env variables were not set for the OS user used. To avoid this, it was suggetsed to use the syb<SID> user.

2) sa login is locked by default in a Business Suite environment.Login sapsa should be used instead

3) Network password encryption is enabled in a Business Suite environment, hence you have to use the option -X when using isql.

Just to clarify, in a Business Suite environment you cannot have more than one "instance" or SID in an ASE dataserver (but it could be possible with MS Sql Server for example).

Regards,

Cris

[former_member308815]

Hi,

I am trying to connect to the ASE server using Command Line. I have logged in with the lroot user. I am running the following command :  isql -S <server_name> -U sa -P <pwd>

In this case, what will be my SID?

Regards,

Anmol Goel

[victoria_normand]

Hi Anmol,

Your System ID (SID) should be indicated after the -S, instead of the <server_name>.

You should be logged as "syb<SID>" user or "<SID>adm", to get the correct variable environment.

User "sa" is locked on SAP Business Suite environment, you should use the "sapsa" or "SAPSR3", ie:

isql -S<SID> -Usapsa -P<sapsa_password> -X

On SAP BS/BW environments we will always need to specify the "-X" flag when using isql. The client password encription is required to be used (ASE configuration parameter "net password encryption reqd" should has a value > 0 , check note 1749935  - SYB: Configuration Guide for SAP ASE 15.7).

Please open another thread if you have further questions as this one is very old and it might still appears as "Unanswered"

Best regards,
Victoria.

[former_member308815]

Hi Victoria,

Thanks for the reply. I have alraedy installed the Sybase ASE and IQ Server and now I am trying to create a new database in that preconfigured server using isql.

Could you please help me with that. How to i connect to IQ server and create a new database using isql?

Regards,

Anmol Goel

[victoria_normand]

Hi Anmol,

Are you using SAP applications ? ( you are talking about IQ, maybe, Business Warehouse ? )
I'm not sure to understand your environment and what you are trying to do.
Outside SAP Applications the command line used to connect to an IQ server (dbisql) is different of the one for ASE (isql). But it would be better to understand first which is your architecture/environment.
Please open another discussion anyway

Best regards,
Victoria Normand.

[dawn_kim]

Hi,

It says it can't find your server name

You can isql these two ways.
isql -Uusername -Sservername_in_the_sql.ini_file

or
isql -Uusername -Sipaddress_of_box_ase_resides_on:portnumber

Thanks,
Dawn

[andreu_mendoza2]

Hi Uday,

I think that your original problem could be that you were not using encryption.

I would try launching ISQL with the -X option "Initiates the login connection to the server with

client-side password encryption. "

Something like:

isql -Usa -Ppassword -X

Regards,

Andreu

[ryan_hansen]

Hi,

Just for clarification.

Original error:

CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer

error: Requested server name not found.

Reason for error:
This is caused when isql doesn't know where to go or what box to connect to.

Resolution:
Make sure there is an entry in the sql.ini.

This file is found in:
%SYBASE%\ini

Example entry:
[indigo6]

master=TCP,indigo6,4747

query=TCP,indigo6,4747

Test connection:

isql -U<username> -P<password> -Sindigo6

You can also bypass the sql.ini file by using -S<host>:<port>

Example:
isql -U<username> -P<password> -Sindigo6:4747

Password encryption error:
isql -Usa -Psybase -Sindigo6

Msg 1640, Level 16, State 2:

Server 'indigo6':

Adaptive Server requires encryption of the login password on the network.

Msg 4002, Level 14, State 1:

Server 'redhead':

Login failed.

CT-LIBRARY error:

        ct_connect(): protocol specific layer: external error: The attempt to co

nnect to the server failed.

Reason for error:
sp_configure "net password", 1

Requires all clients to use password encryption.

Resolution:

add the -X option to isql and make sure all other clients have password encryption enabled.

Example:
isql -Usa -Psybase -Sindigo6 -X

Login Failed error:

isql -Usa -S SBP

Password:

Msg 4002, Level 14, State 1:

Server 'SBP':

Login failed.

CT-LIBRARY error:

        ct_connect(): protocol specific layer: external error: The attempt to co

nnect to the server failed.

Reson for error:

You have established a connection to ASE.

ASE is rejecting the login information (username, password).

This could be caused by:
- fat fingers

- case sensitive

- locked account

- not enough user connections available

- specific security requirements might be enabled for this account (only can connect through ldap, ssl, kerberos)

Resolution:

- verify login information

- check ASE log for any messages

- Run sp_displaylogin <username> to gain more information

1> sp_displaylogin sa

2> go

Suid: 1

Loginame: sa

Fullname:

Default Database: master

Default Language:

Auto Login Script:

Configured Authorization:

        sa_role (default ON)

        sso_role (default ON)

        oper_role (default ON)

        sybase_ts_role (default ON)

        dtm_tm_role (default ON)

        mon_role (default ON)

        sa_serverprivs_role (default ON)

Locked: NO

Date of Last Password Change: Nov 22 2013 10:29AM

Password expiration interval: 0

Password expired: NO

Minimum password length: 6

Maximum failed logins: 0

Current failed login attempts:

Authenticate with: AUTH_DEFAULT

Login Password Encryption: SHA-256

Last login date: Mar  3 2014  8:29AM

Exempt inactive lock: 0

(return status = 0)

[j_raymakers]

Excellent post!

[Former Member]

can any one tell to reset password the above things are not working for me i tried with isql -usapsa....command plz

[ryan_hansen]

Hi,

User sapsa might be an integrated SAP ASE instance if so, this might not work.

Here are the steps if you want to reset sa user.

Regards,

Ryan

changesapassword.txt.zip

[ryan_hansen]

Found this old thread that might help too:
http://scn.sap.com/thread/3638511

[Former Member]

Check what %DSQUERY% is set to. 

Try ruunning isql -Usa -S DSQUERY

Where DSQUERY is the name of the ASE instance as defined in sql.ini

[Former Member]

Hi,

Where can i check %DSQUERY% is set to ???

I tired to login with below query but end up with error,

D:\sybase\SBP\OCS-15_0\bin>isql -Usa -S DSQUERY

Password:

CT-LIBRARY error:

        ct_connect(): directory service layer: internal directory control layer

error: Requested server name not found.

[Former Member]

Replace DSQUERY with the name of your ASE instance.