Update Configuration Database Connection String

Document created by butlerj Support on Nov 20, 2018
Version 1Show Document
  • View in full screen mode
TOPIC
You are trying to update Nintex Configuration database connection string.
INSTRUCTIONS

To update the connection string of the Nintex Workflow configuration database

 

1. Obtain and test the new connection string.

Example (using default database name for Nintex Workflow 2010):

“Data Source=SERVER\InstanceName;Initial Catalog=NW2010DB;Integrated Security=True”

where the value for Initial Catalog is the name of the Nintex Workflow configuration database.

 

Note: Confirm that the new connection string works before proceeding with the update. For more information about building connection strings for SQL Server, see the following TechNet article: Building the Connection URL .

 

2. Edit the following Windows PowerShell script to use your tested connection string.

This script uses the example connection string from the previous step.

 

$farm = Get-SPFarm;

$farm.properties["NW2007ConfigurationDatabase"];

$farm.properties["NW2007ConfigurationDatabase"] = “Data Source=SERVER\InstanceName;Initial Catalog=NW2010DB;Integrated Security=True”;

$farm.Update();

 

Note: The reference to "NW2007ConfigurationDatabase" is correct for all versions of Nintex Workflow for SharePoint.

 

3. Run the edited Windows PowerShell script.

ADDITIONAL INFORMATION

Attachments

    Outcomes