Skip to Content
SAP Adaptive Server Enterprise

How to Run SAP ASE 16 Database in Windows

Tags:

Hi Bloggers,

This topic may seem a little simple, but it really took me some time until I discover how to run thus database since I didn't count with the proper documentation.

These are the steps you should follow:

1) Go to the directory where you installed the database, and go to the ASE-16_0 folder.

Then move to the bin folder.

There, look for the sqlsrvr.exe file.

Now, if you want to start your database, you should run it as administrator.

If you want to be sure that the database instance has started correctly, you should see the following logs.

Now let's see how to start querying with the interactive sql program.

You should configure the database, according to the installation parameters.

In my case:

Lastly, to check if you have connected, you should go to the sql  menu, and check the following options:

Now you can start playing around with the well known SQL.

Remember: SAP ASE is a case sensitive database

Regards,

Emanuel

No comments