Creating Database Manually

If the database login doesn't have sysadmin rights at the time of installation, follow the procedures outlined below prior to Nintex RPA server installation:

  1. Connect to the SQL Server instance

  2. Create the authentication platform database schema

  3. Create the RPA application database

  4. Enter the RPA server addresses

  • These procedures must be performed by a Database or IT Administrator (i.e., a user with administrative rights to the database server)

  • The following required scripts are available in the location from which the Nintex RPA Platform installation files are downloaded:

    aerobase_db_and_user.sql

    Create Minimum DB.sql

Connect to the SQL Server instance

  1. On the database server, open SQL Server Management Studio and connect to the relevant SQL Server instance

Create the authentication platform database schema

To create the authentication platform database:

  1. Open a new query, and drag the aerobase_db_and_user.sql file into the New Query window

  2. Execute the query, and ensure that it runs with no errors

Create the Nintex application database

To create the Nintex application database:

  1. Create a new empty database with the following settings:

    • Database name: set as desired (e.g., Nintex)

      • TIP: Make note of this name, you'll need it when installing the RPA server

    • Owner: login name created when preparing database server

  2. Select this newly-created database (be sure you are working with the correct DB schema).

  3. Open a new query, and drag the Create Minimum DB.sql file into the New Query window.

  4. Execute the query, and ensure that it runs with no errors.

Minimum and recommended permissions to access database

  • For Nintex_Authentication (default name): The minimum MSSQL role for a user is: dbowner.

  • For Nintex RPA application: The minimum MSSQL roles are: dbdatareader, dbdatawriter, and permission to Store Procedure (based on Microsoft SQL Guide).

    Note: To create database table, run the dedicated database script (located in C:\Nintex\RPA\DB) after the installation is complete. After running the script, stop and restart all Nintex services (through C:\Nintex\RPA).

  • The recommended MSSQL role for both authentication and application is dbowner and up.

Enter the RPA server addresses

To enter the RPA server address in the Nintex database:

  1. On the database server, open SQL Server Management Studio and connect to the SQL instance in which the Nintex database is defined.

  2. Select the Nintex database (be sure you are working with the correct DB schema).

  3. Update the dbo.LeoServers table with the FQDN of the RPA server using one of these two methods:

    • Option #1 – Update using a query:

      • Run the following command in a new query view:

        UPDATE LeoServers SET ServerName='RPA Server FQDN';

      - OR -

    • Option #2 – Update through the GUI:

      • Double-click the new database you created, then double-click Tables.

      • Right-click dbo.LeoServers and select Edit Top 200 Rows.

      • In the first and second rows, change ServerName to the RPA Server FQDN.

When you get to the next step of installing the RPA server, be sure to tick the checkbox labeled Skip Aerobase DB creation... otherwise, installation will fail.

-Take me to the relevant step in the RPA Installation Guide-