Ask the Expert

Starting SQLServer with Sybase ASE

I have installed Sybase ASE with SQLServer on my Linux server. I am trying to find out how to start and shutdown SQLServer from command prompt. Does SQLServer automatically start when I log on as 'sybase'? I tried to use isql from command prompt when logged on as 'sybase,' but it doesn't log me on as 'sa.' It says 'invalid password.' I worked with SQLServer and its command is 'net start mssql server'. Is there any command like that in Sybase on Linux?

    Requires Free Membership to View

ASE does not automatically start when you log on as 'sybase.' In Linux, like any other flavors of Unix, you need to go under directory: $SYBASE/$SYBASE_ASE/install and start ASE as follows:

startserver -f RUN_

where is the name of your ASE you installed. For example, if your ASE instance is called then the runfile is called RUN_MY_SERVER etc.

Once you have started ASE, then you can logon to it using isql. If you have forgotten your "sa" password, then I have already written a thread in this forum on how to deal with lost password for 'sa.'

This was first published in July 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: