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:
Open the Password Secure Server Manager.
In “Databases”, disconnect the existing password databases.
Deactivate the license in the Server Manager.
Close the Server Manager.
4. Connect to the New SQL Server
Reopen the Password Secure Server Manager.
Do not sign in.
Select “Basic Configuration”.
Change the SQL server name to the new server.
Save the changes.
5. Complete the Basic Setup
Sign in to the Password Secure Server Manager using the default password
admin.Reapply the license.
Complete the basic setup.
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).