Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 » SAP SQL Anywhere, on-demand edition » Installation


Installing and initializing a cloud (Windows)

Install, initialize, and configure your cloud.


The minimum supported configuration for a cloud includes two cloud partners and one cloud arbiter with high availability enabled. Cloud partners are cloud servers that are identical and oversee all activity between hosts and servers in the cloud. Each cloud partner and the cloud arbiter must be on separate computers to ensure that if one computer fails, your cloud continues to run. Both cloud partners must run constantly and on the same operating system. They must have Internet connectivity and access to your SMTP servers to send alert emails.

  • Time and time zone synchronization   Computers running cloud hosts must have UTC times synchronized to within 30 seconds of each other.

    The hosts running the cloud partners must be located in the same time zone.

  • Host name restrictions   By default, the host name is the computer name. Host names can only contain the following characters: a-z, A-Z, 0-9, minus sign (-), period (.), and underscore (_).

  • Firewalls must allow TCP/IP connections   Configure firewalls for cloud hosts to allow TCP/IP connections to the TCP/IP, HTTP, and HTTPS ports used by each cloud server installed on the host. Configure firewalls on or between hosts that are used to connect to cloud servers to allow TCP/IP connections to the TCP/IP, HTTP, and HTTPS ports used by the cloud server.

    If your firewall blocks incoming application connections, then configure the firewall to allow connections to the dbsrv16 executable. If your firewall blocks outgoing application connections, then configure your firewall to allow outgoing connections from all cloud executables.

    If firewalls are not configured properly, then connections may fail.

  • Cloud Console requires Adobe Flash   Install Adobe Flash on any cloud host where cloud administration is performed.

  • Windows   The My Documents directory for the current user must not be mapped to a network share; otherwise, adding the computer to the cloud as a cloud host can silently fail.

Context and remarks


During the install process several passwords are set, some of which cannot be changed for the life of the cloud. Record the specified passwords and store them in a safe place.

 Install and configure the first cloud partner
  1. Access the SAP SQL Anywhere, on-demand edition software from SAP and run the installer (setup.exe), accepting all license agreements. When prompted, specify the key that was provided to you when you registered.

  2. On the InstallShield Wizard Completed screen, click Configure a new cloud.

    When you click Finish, the installer launches the Cloud Initialization Utility found in the cloud installation directory (for example, C:\Program Files\SQL Anywhere OnDemand 1.0\sa-win64-x64-\Bin64\dbcloudinit.exe).


    Do not run this utility after your cloud is running unless you intend to remove your existing cloud and create a new one. All existing cloud data (including tenant databases) are deleted; this process is irreversible. Before running this utility, you must delete all your hosts except your last cloud partner, and stop the cloud.

  3. In the Cloud name field, give your cloud a name, pick the language you want your cloud to use from the Cloud language dropdown list, and then click Next. The cloud name must conform to the rules for cloud object names.

  4. On the Cloud Administrator Settings window, provide a full name, new user ID, and a password for the cloud administrator, and then click Next.

  5. On the Host and Port Settings window, specify dynamic or fixed host addressing. If you are unsure of what to specify, then check with your system administrator to find out how addressing is configured for your network. For port settings, leave the defaults and click Next. If an error is returned indicating that a port number is already in use, correct the value to an available port.

  6. On the Encryption and Secure Feature Key Settings window, specify an encryption key and a secure feature key to use for the cloud.

    The encryption key is restricted to 7-bit ASCII characters and is used to encrypt the cloud. By default, the cloud uses RSA encryption. To use FIPS encryption for the cloud, specify Use FIPS encryption. You cannot alter the FIPS encryption setting once your cloud is created.

    The secure feature key is used to enforce tenant database isolation. It is restricted to 7-bit ASCII characters and must be between 6 and 128 characters. Secure feature keys cannot:

    • begin or end with a space or single quote
    • contain backslashes, double quotes, or semicolons
    • contain control characters (characters with an ordinal value of less than 32 or the character value 127)

    Click Next.

  7. On the Cloud Certificate Settings window, specify the certificate to use for the cloud and then click Next. If you do not have a certificate, then the cloud creates one for you (RSA encryption with a 2048-bit key).

    The cloud uses certificates to secure communication between cloud servers and the Cloud Console. Unsigned certificates can cause certificate warnings in your browser when you attempt to access the Cloud Console. It is safe to ignore these warnings in a development environment. However, for increased security in your production environment, use a signed certificate.

  8. On the final window of the Cloud Initialization utility, ensure that Launch the Cloud Console is selected, and then click Finish.

    The cloud is initialized, your default web browser opens, and you are prompted to specify the cloud administrator user ID and password.

  9. After you log in, the Cloud Console loads in your default browser ([external link] https://localhost/dbcloud/).

    Accept the certificate warning, if prompted.


    If the Cloud Console fails to load, then try replacing localhost in the URL with the name of your computer and the HTTPS port number.

  10. On the cloud Overview panel, click Add licenses and enter the core license keys you received from SAP. Click OK.

You are about to create a host install that is used to install cloud software on the second cloud partner and the cloud arbiter. This creates a file called dbcloudaddhost.exe, which you run on the two computers.


The computer you designate for the cloud arbiter must have the same operating system and bitness as the cloud partners, so you can create a single host install that you run on the remaining two computers. If the bitness is not the same, then create two host installs (run Create host install twice), specifying the appropriate bitness. If the arbiter server will run on a host with a different operating system, then download the cloud software for that operating system to the cloud.

Context and remarks

Each host install is specific to an operating system and bitness. When you run dbcloudaddhost.exe, it pulls the host install software you created down from the cloud and runs it.

 Install and configure the second cloud partner and the cloud arbiter
  1. On the computer where you installed the first cloud partner, in the Cloud Console, navigate to the Hosts panel.

  2. On the Hosts panel, click Create host install. If prompted, accept the certificate and continue.

  3. For Host install type, select Multiple use because you are going to use the install more than once: once on the computer that will serve as cloud partner, and once on the computer that will serve as the cloud arbiter.

  4. For Valid for (days), specify the number of days the install is available before it is removed from where it is stored in the cloud, or accept the default (recommended).

  5. For Install can be run on, select Restricted and enter the names and/or IP addresses for the computers that will host the second cloud partner and the cloud arbiter. For security purposes, this method is recommended for adding more than one host to the cloud. Alternatively, you can accept the default, Unrestricted - can be installed on any machine.

  6. For Install version, select the platform/bitness of the host where you are going to run the host install.

  7. For Installation directories, specify the location to install the software and application data to, or accept the defaults (recommended).

  8. For Server ports, accept the default ports that the cloud servers will use (recommended), or specify different ports.

  9. Leave Create and start a cloud server on the host selected.

  10. Click Create and Download to create and download the dbcloudaddhost.exe file. The file is downloaded to the default download location for your browser.

  11. Copy dbcloudaddhost.exe to the computers that will host the second cloud partner and the cloud arbiter, and run it on each computer.

  12. Specify your cloud user name and password when prompted.

    dbcloudaddhost.exe performs the following operations:

    • Downloads the correct cloud software from the cloud to the host you are installing

    • Installs the cloud host software

    • Adds the host to the cloud

    • Creates and starts a cloud server

    • Cleans up local install files

  13. After you have run dbcloudaddhost.exe on both computers, log in to the Cloud Console to confirm that the cloud now has three cloud servers running.

  14. In the Cloud Console, navigate to the Overview panel.

  15. Under High Availability, click the Configure high availability link.

  16. In the Cloud High Availability window, set the cloud partner and the cloud arbiter by selecting the cloud servers running on the hosts you installed, then click Finish.


High availability is now configured and enabled for your cloud, and cloud setup is complete. You can start adding tenant databases to your cloud.


You are now ready to add more hosts, cloud servers, and tenant databases to the cloud.

 See also