Support Centre

Find articles, help and advice.

 
Welcome, Guest Login

Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Default password for Sybase / SA account

Mathew Allbright Feb 18, 2014 02:21PM UTC

Hi

I am trying to change the database administrator password as per page 121 of your BES Install guide, however, not able to change the password as do not know the default for sybase / sa account.

Are you able to advise?

In /opt/sybase/OCS-15_0/bin I run isql -Usybase where I am prompted for the password. I've tried a couple but keep getting the following:

ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

Regards

Up 1 rated Down
David Harwood Feb 18, 2014 03:13PM UTC Interlink Software Agent
DH: Hi Mathew,

There isn't a sybase user created in sybase by default, so unless you have manually created this that user would not exist. The default Sybase sa password is blank (null) – no password set.

Are you looking to change the password for the sa user or do you want to change the password for the ppadmin user in the BSD?

Regards,
David
Up -1 rated Down
David Harwood Feb 19, 2014 02:31PM UTC Interlink Software Agent
DH: Hi Mathew,

Did the above answer help? Do you require more information?

Regards,
David
Up -1 rated Down
Mathew Allbright Feb 21, 2014 09:05AM UTC
Hi

Sorry for the confusion (my head is spinning with all this BES building stuff, however learning so much in the process).

It is the SA user I am looking to apply a password too.

Would I do this via the isql command?

Regards
Up 1 rated Down
David Harwood Feb 21, 2014 09:52AM UTC Interlink Software Agent
Hi Mathew,

Yes you would do this via the isql command. You would first need to login as the sa user then use the sp_password command to change the password:

isql -Usa -P -S<server-name>
1> sp_password null, <new_password>
2> go

Regards,
David

This question has received the maximum number of answers.

Contact Us

desk.com@interlinksoftware.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete