on 11-20-2012 6:31 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
Found this old thread that might help too:
http://scn.sap.com/thread/3638511
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.