Migrating the MSSQL Database to Another Server/Cluster

Goal

This article describes how to migrate the MSSQL databases of your Netwrix Password Secure Server to a new SQL server or cluster.

Prerequisites

• 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 server
• A service account with dbCreator rights on the new SQL server (alternatively, the npwsConfigDb database can be created manually on the new server and assigned to the service account)

Steps

1. Create a backup. Create a full backup of all Password Secure databases and their associated certificates.
2. Restore the database. Restore the data database (e.g., npwsCompanyDataDb) on the new SQL server.
3. Recreate the configuration database. The npwsConfigDb database cannot be migrated and must be recreated.

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

   • Open the Password Secure Server Manager.
   • Under "Databases", disconnect the existing password database.
   • 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).

Note: After a successful migration, restart the Password Secure services to verify that everything starts up correctly.