Configure databases

This section provides instructions for Nintex Workflow and Forms database configurations.

Nintex Workflow requires a configuration database. While the configuration database can technically serve as the sole content database for Nintex Workflow and Forms, we recommend multiple content databases to ensure high availability. For more information, see Content databases and performance.

To set up configuration and content databases

1. Create a Nintex Forms configuration database:

   1. On the Central Administration Home page, click Nintex Administration and then click Database management under Licensing and setup.

   2. Click Add Nintex Forms configuration database.

      When Nintex Forms is newly installed, the Nintex Forms database setup page displays default settings for the Nintex Forms database.

   3. If needed, edit the database settings.

   4. Click OK to create the database.

2. Create a Nintex Workflow configuration database:

   1. On the Central Administration Home page, click Nintex Administration and then click Database management under Licensing and setup.

   2. Click Add Nintex Workflow configuration database.

      When Nintex Workflow is newly installed, the Add configuration database page displays default settings for the Nintex Workflow configuration database.

   3. If needed, edit the database settings.

   4. Click OK to create the database.

      Note: The default value for Database Server is the default SharePoint database server.

      A database connection string appears in the Configuration Database section.

3. (Optional but recommended.) Add content databases as needed to store workflow and task history (optional; see Content databases and performance):

   1. To redisplay the database management page, on the Central Administration Home page, click Nintex Administration and then click Database management.

   2. For each content database to be added, do the following:

      1. In the Content Databases section, click Add content database.

      2. In the Add content database page, enter the name of your database server and a database name; leave all other settings as default.

      3. Click OK.

         A database connection string appears in the Configuration Database section.

   3. (Optional.) Update content database parameters using the NWAdmin operation UpdateContentDatabaseParameters.

      For instructions on setting the content database to AlwaysOn, see Set content databases to AlwaysOn.

4. (Optional but recommended.) Map Nintex content databases to SharePoint content databases:

   1. On the Central Administration Home page, click Nintex Administration and then click Database management under Licensing and setup.

   2. Click Manage under Content database/s.

   3. For each SharePoint content database corresponding to a site collection that uses Nintex Workflow, select a Nintex Workflow content database under Map to Workflow Content Database.

      For more information about database mapping for Nintex Workflow, see Database Design Guide: Nintex Workflow.

   4. Click OK.

5. Run the IISreset command to implement the changes:

   1. Start a command prompt as an administrator.

      For instructions, see the following TechNet article: http://technet.microsoft.com/en-us/library/cc947813(v=WS.10).aspx

   2. Enter the following command.

      IISreset