- 4 minutes to read

Validation and DACPAC Registration

In the new SQL Server instance, the Nodinite version in use needs to be correctly registered.

Note

Nodinite v7: DACPAC version registration is partially automated. The PowerShell installation script handles Agent and Configuration databases automatically. Log Databases require manual script execution from Administration | Settings | Log Databases in the Web Client.

Register DACPAC

For Nodinite v7:

Configuration Database and Agent Databases

  1. Download the latest Nodinite 7 installation package from the Nodinite portal (or use your currently downloaded version)
  2. Run the PowerShell installation script: Nodinite7-%ENVIRONMENTNAME%-Installation.ps1
  3. The script will automatically detect and register the correct DACPAC versions for:
    • Configuration Database
    • Agent databases (Monitor Agent, Log Agent)
  4. Verify registration in Administration | Settings | Log Databases - these databases should show the correct version

Log Databases

  1. Navigate to Administration | Settings | Log Databases in the Web Client
  2. For each Log Database, locate the manual update script
  3. Using a command prompt as the service account for the Nodinite Logging Service, run the provided script
  4. Verify registration - the version number should match your Nodinite version
  5. Repeat for each Log Database

For Nodinite v6 (Legacy):

Follow the manual DACPAC registration process described below.

Configuration Database (v6 Legacy)

To register the DACPAC for the Configuration database in Nodinite v6:

  1. Using a remote desktop session on the Nodinite Server, start a command prompt as the service account used as the installation account for Nodinite
  2. Navigate to Administration | Settings | Log Databases in the Web Client to obtain the manual update script
  3. Paste the script for the configuration database and wait for it to finish (review the Manually update database user guide for additional information)

    Important

    If this step fails, please retry the operation at least once

  4. Validate registration in Administration | Settings | Log Databases - the version number should match your Nodinite version

Logging Database (v6 Legacy - Manual Process)

For Nodinite v6 using the legacy Install and Update Tool:

  1. Using remote desktop on the Nodinite Server with the Logging Service, start a command prompt as the service account used for the Nodinite Logging Service
  2. Use the Install and Update Tool to generate the manual update script
  3. Paste the script for the logging database and wait for it to finish (review the Manually update database user guide for additional information)

    Important

    If this step fails, please retry the operation at least once

  4. Validate registration in the Install and Update Tool - the version number should match your Nodinite version
  5. Repeat for each Logging Database

Start the IIS - Application Pools

Start all the stopped Nodinite application pools. Review the IIS Authentication settings user guide for additional information.

Important

Do NOT start the Windows Services yet.

Basic Validation Tests

Nodinite v7: Navigate to Administration | Tools | Nodinite Overview in the Web Client to access quick links to all Nodinite Core Services.

Nodinite v7 Overview with clickable links
Example: Nodinite v7 Overview page with clickable URI links.

Nodinite v6: Navigate to the Overview page in the Web Client (Administration | Tools | Nodinite Overview) to view URIs for all Nodinite Core Services. The URIs are displayed but not clickable—copy and paste them into your browser.

Nodinite v6 Overview with URIs
Example: Nodinite v6 Overview page displaying Core Services URIs (copy/paste to use).

Validate that all Core Services are working correctly:

Log API Test

Nodinite v7: Navigate to Administration | Tools | Nodinite Overview in the Web Client, then click the Log API link.

Nodinite v6: From the Overview page, copy the Log API URI and paste it into your browser.

  • Browse the Swagger interface or insert a JSON Log Event example, then verify it appears in the Admin Log View

Web API Test

Nodinite v7: Navigate to Administration | Tools | Nodinite Overview in the Web Client, then click the Web API link.

Nodinite v6: From the Overview page, copy the Web API URI and paste it into your browser.

  • Using the Swagger feature, perform a test of the Get operations for Roles. All roles should be returned in the response JSON

Web Client Test

Nodinite v7: Navigate to the Web Client home page.

Nodinite v6: From the Overview page, copy the Web Client URI and paste it into your browser.

  • Perform a search in the Admin Log View and verify that there are Log Events in the search result

Database Status Verification

From Administration | Settings | Log Databases in the Web Client, verify:

  • Server name(s) match the new SQL Server environment
  • Database name(s) are correct
  • Version numbers match your Nodinite version
  • All Log databases are listed as operational

LogDatabaseOperational.png

Next Step

Validation successful? Continue with final steps: