Skip to Content
Technical Articles
Author's profile photo Denys van Kempen

SAP HANA, express edition 2.0 SPS 05

Long story short: SAP HANA, express edition 2.0 SPS 05 has been made available for download as of June, 30 2021.

You can run the express edition inside a virtual machine or download the binaries for installation, either on your own computer (provided enough resources are available) or on a cloud-hosted VM.

The express edition comes with support from the SAP Community which unfortunately tends to duplicate and scatter a bit with some nuggets even spilling into Stack Overflow. Hence, in a modest effort to provide an anchorpoint for the FAQ’s, tips, hacks, and other information, here is a blog post about the latest SPS05 edition.

The SAP HANA, express edition is the perfect companion to get certified on the SAP HANA platform. For the ins and outs, see

Questions? Please post as comment.

Useful? Give us a like and share on social media.



Hands On 

Cloud versus Express

SAP HANA, express edition first appeared with the SAP HANA 1.0 SPS 12 release in 2016 with a free license for development purposes. Since, the focus of SAP development changed to cloud-first in 2018 with the SAP HANA service followed by SAP HANA Cloud in 2020 with updates every quarter. As a consequence, should you be interested in the latest features and functionality for SAP HANA, we suggest to consider the cloud edition.

For the platform edition on-premises, the release cycle switched to a slower cadence with the SPS 05 release going back to June 2020 and with SPS 06 planned for December 2021.

A little later but just in time for the end of mainstream maintenance support of the SPS 04 and all previous releases, we can now welcome the express edition for SPS 05.

Unlike the cloud edition, where you are up and running in a few clicks, working with the express edition requires a bit more effort and skill. First we need to to download the software, which requires a download manager, which requires a Java runtime (we cover a few of the first hurdles below). Next, you either need to install the software (advanced) or run it as virtual machine and here again, you may need to tweak and fiddle with configuration settings to get the virtual networking working and be able to connect with a client running on your host computer. Next, we may wish to make changes to the SUSE Linux operating system (for example to receive support pack updates) or the SAP HANA database (for example to update certificates). For those less familiar with a command line interface and tools like yast and vi, hdbsql, editing /etc/hosts files, and similar activities, you may find working with SAP HANA, express edition a bit challenging at times. Again, for ease of use and the latest functionality, consider SAP HANA Cloud. For those that enjoy tinkering, please proceed.

To download the (download manager for the) express edition, you visit the SAP Store first for window shopping and promotion material

Alternatively, proceed directly to the sign-up page

To download the HANA tools Eclipse plugin a.k.a. SAP HANA studio, go to

Learn More

For the latest blog posts and Q&A on the topic, follow the SAP HANA, express edition tag

For the latest tutorials, visit the SAP Developer Center

SAP HANA Academy YouTube Tutorials

Although the latest tutorial was recorded in 2018, you may still find some questions answered by the videos on the playlist


Getting Started

Download Manager

On macOS, when you double-click the downloaded JAR file, you will get a warning that the file cannot be opened because it is from an unidentified developer. One workaround is to open the file while holding the control key and answer the are-you-sure question affirmatively.

Next, the file may not execute because a Java Runtime could not be found. Again, multiple solutions, one of which is to download the SapMachine JDK. For macOS, as documented, run command

brew install sapmachine-jdk

For the other operating systems and fine print, visit

Start the download manager with the java command.

java -jar HXEDownloadManager.jar

Getting Started Guide

Before downloading any software, you may want to start with the Getting Started installation guide for information about the packages and any issues you may encounter.


The Getting Started guide documents 8 GB RAM minimum for the server-only virtual machine and 16 GB RAM minimum, 24 GB RAM recommended for the server plus applications VM, i.e. SAP HANA database plus the XSA runtime environment with all provided applications. To this you need to add (at least) 4 GB for your host operating system. In other words, for smooth sailing with some margin of comfort and rounding off numbers, you need a computer with 16 GB for the database VM and 32 GB for the database with XSA.

VMware Side Channel Mitigations

When starting the VM, you may get a message that you are running with side channel mitigations enabled and that this provides enhanced security but also lower performance. For a local laptop dev box, you can disable side channel migration under the advanced settings of the VM. For the fine print, see


The Getting Started Guide documents (p. 25) how to configure VMWare Workstation on Microsoft Windows in case the VM starts without an IPv4 address by using Bridged Networking settings. This may or may not solve the issue.

Notice that the ifconfig command shows an IPv4 and IPv6 address for the loopback adapter (lo) but only an inet6 address for the eth0 virtual NIC.

Changing the network adapter setting for the VM from bridged networking to “Private to my Mac”, changes this behaviour and provides an IPv4.

Upon startup, the welcome message displays an IP address. If you want to connect with Terminal, SAP HANA studio, or any tool installed on your computer, add an entry to the /etc/hosts file.

SAP Issue

For those with a sharp eye, you may have noticed that the Welcome message displays SAP HANA, express edition 2.0 SPS04. Should you prefer this message to be factually correct, you can easily modify this by editing the file /etc/issue-sap as root.

sudo vi /etc/issue-sap



Caveat Emptor

Of course, we all read the documentation and prefer to do things right but every once in a while you might find yourself a bit of a hurry, need to get something done, and care a little less about how the objective is achieved. Here we enter the space of the workarounds, the quick fixes,  a.k.a. gambiarras.


What follows are hacks and workarounds which may or may not solve the issue but are generally considered bad practice.


Upon first log on you were prompted to change the password from the hxeadm user to a hard-to-guess password as security good practice. But what-if you have a developer policy to always use the same easy-to-guess password to avoid forgetting your passwords or having to write them down? For those situations and more, you could consider to activate the root user.

As the hxeadm user edit the file /etc/passwd and change the root entry.

sudo vi /etc/passwd
# change /sbin/nologin to /bin/bash

You can now login as root or use the interactive sudo command to start a root session.

hxeadm> sudo -i
root # passwd hxeadm


Of course, the Peter Parker principle applies: With great power comes great responsibility. Make sure you are in the /var/tmp and not in / before executing rm -rf.


Share and Connect 

Questions? Post as comment.

Useful? Give us a like and share on social media. Thanks!

If you would like to receive updates, connect with me on

Over the years, for the SAP HANA Academy, SAP’s Partner Innovation Lab, and à titre personnel, I have written a little over 300 posts here for the SAP Community. Some articles only reached a few readers. Others attracted quite a few more.

For your reading pleasure and convenience, here is a curated list of posts which somehow managed to pass the 10k-view mile stone and, as sign of current interest, still tickle the counters each month.

Assigned Tags

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

      Quite insightful.....thanks for sharing

      Author's profile photo Uwe Fetzer
      Uwe Fetzer

      See also Tutorial Group "Upgrade SAP HANA, express edition" to upgrade from previous releases

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Comment cannot be empty

      Author's profile photo Uwe Fetzer
      Uwe Fetzer

      Looks like with SPS 05 (coming from 04) it doesn't work anymore

      SAP HANA Lifecycle Management - SAP HANA Express Edition
      rpm package 'libatomic1' needs at least version 9.2.1. (current version = 8.2.1+r264010)
      rpm package 'libgcc_s1' needs at least version 9.2.1. (current version = 7.3.1+r258812)
      rpm package 'libstdc++6' needs at least version 9.2.1. (current version = 7.3.1+r258812)
      The operating system is not ready to perform gcc 9 assemblies
      For more information, see SAP Note 2886607.
      Checking system requirements failed

      (VM Version)

      Author's profile photo Uwe Fetzer
      Uwe Fetzer

      Downloading the rpm packages from (etc.) and installing with "sudo zypper install ...." solved the problem 🙂

      Author's profile photo Fábio Luiz Esperati Pagoti
      Fábio Luiz Esperati Pagoti

      Hello Denys van Kempen ,


      I noticed that HANA Express Edition solutions were removed from CAL and from AWS Marketplace. I believe this has to do with the end of support from previous versions.


      However do you know if SPS 05 will be available in CAL or AWS Marketplace? If yes, do you when it should be available?



      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Fabio,

      The cloud-hosted SAP HANA, express edition was retired from the different cloud provider marketplaces and SAP Cloud Appliance Library last year, well before the end-of-mainstream-maintenance date.

      Instead, we can use the SAP HANA Cloud trial, which is container-based, not VM-based, and much more adapted to cloud environments.

      You can install the binary version on a cloud-hosted VM and there are probably migration tools/services as well to convert the VM into a cloud-hosted one, should you prefer this approach.

      Author's profile photo Fábio Luiz Esperati Pagoti
      Fábio Luiz Esperati Pagoti

      Perfect - thank you.

      Author's profile photo Thomas Yuan
      Thomas Yuan

      Hi Denys van Kempen

      It seems some components in SPS 04 aren't available any more in SPS 05, such as EA Designer and DWF. Is it permanent?


      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      Hi Thomas,

      EA Designer passed end of mainstream maintenance in April 2021 and no longer available, see


      Data Warehousing Foundation is still supported for SAP HANA, platform edition 2.0 SPS 05 but no longer included with SAP HANA, express edition 2.0 SPS 05, as documented in the feature scope description (FSD)

      Author's profile photo Thomas Yuan
      Thomas Yuan

      Thanks for clarification!

      Author's profile photo Piotr Tesny
      Piotr Tesny

      Hello Denys and Fellow Readers,

      For the sake of completeness SAP offers ready-to-deploy HANA Express docker images as well.

      If interested, you may refer to my own blog post(s), namely Taming SAP HANA Express database Docker edition with MacOS – prepare, to start with, for more information.

      Thanks; Piotr

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      For information about how to install SDI, see

      Author's profile photo Denys van Kempen
      Denys van Kempen
      Blog Post Author

      To (re-) install VMware tools, see VMware KB 1018414

      Enable shared folders in Virtual Machine > Settings

      Files are accessible from /mtn/hgfs/<shared folder>

      ls /mnt/hgfs/Downloads