Viewing and updating referenced database server names

This section describes how to view and update referenced database server names for Nintex Workflow databases. Confirm that current servers are referenced for all Nintex Workflow databases (configuration and content).

Note: Although the examples reference the default database name for Nintex Workflow 2010, the scenario and instructions apply equally to Nintex Workflow 2013.

To view the referenced database server names

• Using SQL Server Management Studio, run a SQL query on the following table in the configuration database: dbo.Databases

  For example, run the "Select Top 1000 Rows" query that is listed when you right-click the dbo.Databases table.

  In the following example result, the dbo.Databases table in the configuration database references the same database server name “SQL1\Instance1” and failover partner “SQL2\Instance1” for all listed databases.

  

  If the referenced database server names are not on the current server, then update the names for each database using the following procedure.

To update the referenced database server name for a database

1. Back up the database.

   Note: A database backup is essential; this SQL query modifies the database.

2. Edit the following SQL query to reference your configuration database and new database server.

   UPDATE [configdb].[dbo].[Databases]

   SET [ServerName] = 'newserver';

   where configdb is the name of your configuration database and newserver is the name of the new database server.

   Note: This query updates the referenced database server name for all databases listed in dbo.Databases. If the databases in your environment are on separate servers, edit the query accordingly.

   For example, the following SQL query updates the referenced database server names for the NW2010DB database to “DRSQL1\Instance1” and removes the failover partner identifiers.

   UPDATE [NW2010DB].[dbo].[Databases]

   SET [ServerName] = 'DRSQL1\Instance1',

   [FailoverPartner] = '';

3. Run the edited SQL query.

   Following is an example result.