Open topic with navigation

Databases

Successful installation of Nintex Workflow requires that a configuration database exist as well as any additional Nintex content databases needed for your environment; all Nintex content databases must be mapped to the corresponding SharePoint content databases. For more information, see Content databases and performance.

For Nintex Forms, confirm that the automatically created database exists. See Nintex Forms configuration.

In addition to ensuring that all required databases are set up, confirm that the web application user accounts are members of the custom database role WSS_Content_Application_Pools for all Nintex databases. This membership configuration is completed by the Nintex installers; the WSS_Content_Application_Pools database role has all required SELECT and EXECUTE rights to the database required for Nintex functionality.

To confirm database role memberships for web application user accounts

1. Identify the names of all web applications used by Nintex.

   1. On the Central Administration Home page, click Application Management.

   2. In the Web Applications section, click Manage web applications.

      Example name of web application: SharePoint - 80

2. Identify the user account for each web application.

   1. On the Central Administration Home page, click Security.

   2. In the General Security section, click Configure service accounts.

   3. In the Service Accounts page, select the web application name identified in the previous step.

      Note: The web application name is prefixed by the phrase "Web Application Pool." 
      Example: Web Application Pool - SharePoint - 80

      The user account for the web application is identified under Select an account for this component.

      Example user account: NINTEXTEST/PM13-SPWebApp01

3. View the database role membership for each user account on all Nintex databases.

   1. View the login user accounts for the database server containing the Nintex databases: In Microsoft SQL Server Management Studio, expand the database server folder, expand the Security folder, and then expand the Logins folder.

   2. Double-click the user account identified in the previous step to display the properties dialog box.

   3. Click the User Mapping page to view the databases mapped to the login user account.

   4. For each Nintex database:

      1. Confirm that the check box for the database is selected.

      2. Select the database to display the database role memberships, and then confirm that the check box for WSS_Content_Application_Pools is selected.

      If the check box for the database is not selected, or if the check box for WSS_Content_Application_Pools is not selected, go ahead and select it and then click OK.

Open topic with navigation