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

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., Kryon)

     • 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 Kryon_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:\Kryon\RPA\DB) after the installation is complete. After running the script, stop and restart all Nintex services (through C:\Kryon\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

       

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