Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Cannot Open "Database Setup" In Central Administration After Configuration Database Migration

    Status: Pending Clean Up

    ISSUE
    When accessing Setup Database in Central Administration, after a migration has been performed, the following error might occur:

    Object reference is not set to an instance of an object.
    ERROR CODE
    RESOLUTION
    First verify that the connection string shows the correct server and database name, using SharePoint 2013 Management Shell:
    $farm = Get-SPFarm;
    $farm.properties["NW2007ConfigurationDataBase"];
    • If the server and database names are correct skip the next step.
    If the string is incorrect run the following:
    $farm = Get-SPFarm;
    $farm.properties["NW2007ConfigurationDataBase"];
    $farm.properties["NW2007ConfigurationDataBase"] = ??;
    $farm.Update();
    Try the Database Setup page again.

    If the error still appears:

    1. Open SQL Manager and navigate to the Nintex Configuration database
    2. Go to: Tables > dbo.Databases > Right click "Select Top 1000 Rows"
    If the server name is incorrect:
    1. Run the stored procedure (Programmability > Stored Procedures) "dbo._PrepareForNewEnvironment", this will purge all of the old data from the Databases and Storage tables.
    2. In Central Administration > Nintex Workflow Management > Database Setup, add the new Config and Content databases, please ensure that the "connect to an existing database" check box is selected.
    ADDITIONAL INFORMATION
    This is due to an outdated connection string that contains an invalid server name or database. This could be an old server connection, or you may have the old server name in the Nintex Configuration Database table dbo.Databases.
    RELATED LINKS
    • Was this article helpful?