Welcome > Azure setup > Create the Azure database

Create the Azure database

Create the Azure database using the Azure Management portal.

Note You must note down the server name, username and password for future use.

  1. Open the Azure Management portal.
  2. Go to SQL DATABASES > SERVERS.

    SQL Databases

  3. Click ADD.

    SQL database server settings

  4. Enter SQL database server settings and click the Tick button.

    New database server is created.


    Database Server

  5. Create a Master database called ‘MasterTenants’ in one of the available servers.
    Note Use a different name for the database if desired. This database will be used later by the Tenant Management website to manage tenants and create Data Center and storage.
  6. To create a new database, click the selected database server.

    The database server Quick Start page opens.


    Create Database

  7. Under Common Tasks, click Create Database.

    Specify database settings

  8. Specify database settings and click the Tick button.

    This will create a new database.

  9. Similarly, create the Data Center database called DataCenterTenants.

    This database will be used later by the Data Center instances.

    Note the following:

    • Use a different name for the DataCenterTenants database if desired.

    • A Data Center should have only one DataCenterTenants database.

    • The Master and the Data Center databases need not be on the same server.

    • Kofax recommends creating the Data Center databases on the same region as the DataCenter instances.

  10. Once the two databases are created, create the necessary tables and their initial data.

    Database tab

  11. Click the DATABASES tab.
  12. Make sure your database is Online.
  13. Click MANAGE.

    A message appears, “The current IP address <IP address> is not included in the existing firewall rules. Do you want to update the firewall rules to manage Tenants?”

  14. Click Yes. A message appears, “Rule <rule> to <rule> was added to the firewall rules. Do you want to manage Tenants now?”

    Rule message

  15. Click Yes.

    A New database logon window opens.


    SQL database window

  16. Type your username and password and click Log on.

    The Database console opens.


    New Query

  17. Click New Query or Open and run the Master Tenant scripts located at \Support\Scripts inside the Azure Package folder on the ‘MasterTenants’ database in the following order:
    1. Create_MasterTenants.sql
    2. Initialise_MasterTenants.sql
  18. Perform the same steps to run the Data Center scripts located at \Support\Scripts inside the Azure Package folder on the ‘DataCenterTenants’ database in the following order:
    1. Create_DataCenterTenants.sql
    2. Initialise_DataCenterTenants.sql
    3. Create_KLS_Azure.sql – these are license tables
    Note Drop scripts are available at the same location if you need.
  19. Now all database prerequisites are ready.
  20. Open the Master Tenants/DataCenterTenants database Quick Start page to view the full address to database server.

    Server address

  21. Make a note of this address as you will need it for configuring the ServiceConfiguration.cscfg file of CEBPM Azure deployment package.