We're updating some of our product names. K2 Five is now Nintex Automation. You may see both product names in our help pages while we make this change.

Microsoft SQL Server

For information on what versions of SQL server are supported for installation of the database and by the SQL Server Service Broker, please see the Compatibility Matrix.

Installing databases on SQL Server

The product installation creates the database on a Microsoft SQL Server instance. The installing account will require sufficient permissions to create the databases on the target SQL instance.

The Setup Manager determines where to install the database based on the location of the SQL Master database.

If you use a SQL Alias, please see the topic SQL Server in the Prepare section of this guide.

Integrating with SQL Server

Apart from installing the database on Microsoft SQL server, the product can also interact with Microsoft SQL through the SQL Server Service Broker. You can register a Service Instance of this broker to connect to a SQL database, and then create SmartObjects that expose the Tables, Stored Procedures and Views. These SmartObjects can in turn be consumed by SmartForms, workflows, reports and other SmartObject consumers.

There are no specific installation steps required to install this Service Broker, it is included and available by default in a Nintex Automation environment.

SQL User Manager (SQLUM)

You can use SQLUM as a user manager for the product by selecting it during installation. Configuring SQL as the user manager is only available if Active Directory is not detected during installation. See Configuring the SQL User Manager for more information.