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 SP 6 » Tenant databases » Connections to tenant databases

Connecting to a database in a cloud (SQL Anywhere administration tools)

Connect to a database that is currently running in the cloud by using the Connect window with the Connect to a running database in a cloud option.


To connect to a database in the cloud, supply at minimum the host name, the port number, the name of the database, and the user ID and password for the database.


To ensure that you can connect to the cloud, specify the hosts and ports for cloud servers that are using fixed ports and that are expected to be running all the time.


  1. In SQL Central or Interactive SQL, open the Connect window.
  2. Complete the following fields:
    1. In the Authentication dropdown list, click Database.
    2. In the User ID field, type a user name. For example, type DBA.
    3. In the Password field, type a password for the user. For example, type sql.
    4. In the Action dropdown list, click Connect to a running database in a cloud.
    5. In the Host field, type the host name of any cloud server that uses fixed ports.
    6. In the Port field, type the TCP/IP port of the cloud server.
    7. In the Database Name field, type the name of the database. For example, type Tenant1.
    8. Optional: To specify the NodeType (NODE) connection parameter, click the Advanced Options tab and select the desired node type in the Value field for the NodeType parameter.
  3. Optional: To obtain a copy of the connection string that is created with this window, click Start of the navigation path Tools Next navigation step Copy Connection String to Clipboard End of the navigation path.
  4. Click Connect.


The administration tool connects to the database.