Migrating the MSSQL Database to Another Server

Purpose

This article describes the process of migrating the MSSQL databases of the Netwrix Password Secure Server to a new SQL server.

Prerequisites

Before beginning the migration, ensure you have the following information and permissions:

• Password for the Password Secure Server Manager

• Access credentials for the license server or a license file

• Access credentials for both the old and new MSSQL servers

• A service account with dbCreator rights on the new SQL server

  • Alternatively, the database npwsConfigDb can be created manually on the new server and assigned to the service account.

Procedure

1. Create a Backup

Create a full backup of the following components:

• All Password Secure databases

• All associated certificates

2. Restore the Database

Restore the data database (e.g., npwsCompanyDataDb) on the new SQL server.

3. Create the Configuration Database

The configuration database npwsConfigDb cannot be migrated and must be recreated.

Steps:

1. Open the Password Secure Server Manager.

2. In “Databases”, disconnect the existing password databases.

3. Deactivate the license in the Server Manager.

4. Close the Server Manager.

4. Connect to the New SQL Server

1. Reopen the Password Secure Server Manager.

2. Do not sign in.

3. Select “Basic Configuration”.

4. Change the SQL server name to the new server.

5. Save the changes.

5. Complete the Basic Setup

1. Sign in to the Password Secure Server Manager using the default password admin.

2. Reapply the license.

3. Complete the basic setup.

4. Navigate to “Databases” → “New” → “Existing Database” and attach the restored data database(s).

Notes

• After the migration is complete, it is recommended to restart all Password Secure services to verify that everything starts up correctly.

• In environments with multiple Password Secure Servers, each server must have its own npwsConfigDb (e.g., npwsConfigDb_SERVER1).