Skip to Content
Author's profile photo Former Member

Getting started after installing SAP ASE 16.0 SP02 on Windows

You can download SAP Adaptive Server Enterprise from the SAP Software Download Center http://

The steps below assume that you have chosen default settings during installation.

Start and Stop Servers

After you install your ASE on Windows, you can start and stop your server in your local services (just search for “services” on your computer and click on “View local services”).

Or you can start the server using RUN_<server_name> files.

Access SQL Console

There are two ways to access the SQL console.

You can log in to the isql console from the command prompt using “isql –U<username> -P<password> -S<your_server_name>”. The default user is “sa”.

You’ll see 1> in the next line if login is successful.

Try making a simple query to the sample database pubs2:

Use “exit” to exit the isql console.

For Interactive SQL console, open Interactive SQL app or run dbisql.exe from SAP\DBISQL-16_0\bin.

To test it, select a sample database in the top right corner and make a simple query. Click the play button to see query results.

Logging in to Cockpit

To access cockpit (a web-based management and monitoring tool), make sure that COCKPIT-4 is running in your local services (it should have been started automatically by the installer). If it’s not running start it from your local services or by running cockpit.bat from SAP/COCKPIT-4/bin.

Then, in your browser, type https://<hostname>:4283/cockpit. This assumes that during installation you chose the default port 4283.

You’ll need to continue to the website, even if your browser doesn’t recommend it. The default user is “tech_user”.

After you log in, you should see the “Monitor” screen:


Leave a comment if this post was helpful or to let me know how I can improve it.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Gaurav Sinha
      Gaurav Sinha

      Hi Dominika,

      I assume ASE cockpit also keeps historical data for trend analysis, if yes then does it need its own separate database like a saptools to keep historical data?

      Author's profile photo Former Member
      Former Member


      ASE Cockpit does not require a separate database to store the historical monitoring and alert data that it uses.  This data is stored in an embedded database that is managed by the ASE Cockpit program.

      This historical data can be accessed from the Statistics Chart tab in the ASE Cockpit Monitor screen.

      - Peter