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

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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