How to migrate a Microsoft SQL database to a new database server
Objective
This article outlines the steps to migrate the back-end Microsoft SQL server database of ADSelfService Plus to a new Microsoft SQL server. This process keeps the existing ADSelfService Plus application server intact and only changes the database it connects to.
This migration is essential for common IT scenarios, such as decommissioning an old server, upgrading your SQL infrastructure, improving application performance, or relocating your database as part of a data center migration.
Prerequisites
Before starting the migration process, ensure the following:
- You have administrator access to the ADSelfService Plus application server.
- You have access to both the old and new Microsoft SQL servers.
- You've made a full backup of the ADSelfService Plus installation directory.
- The new SQL server firewall must have the same exceptions as the old server, allowing connections from the ADSelfService Plus application server.
- You have sufficient privileges on both SQL servers to perform backup and restore operations.
Steps to migrate a Microsoft SQL database
Step 1: Back up and restore the SQL database
- On your current Microsoft SQL server, perform a full backup of the ADSelfService Plus database.
- On the new Microsoft SQL server, restore the database backup from the backup file you just created.
Note: If prompted for a master key during restoration, contact ADSelfService Plus support to generate or retrieve it from the existing ADSelfService Plus application server. Step 2: Reconfigure ADSelfService Plus to connect to the new server
- Stop the ManageEngine ADSelfService Plus service via services.msc. This step is mandatory to prevent data corruption.
- Open Command Prompt as an administrator.
- Navigate to the bin directory within the ADSelfService Plus installation folder. The default path is C:\Program Files\ManageEngine\ADSelfService Plus\bin.
- Execute the database configuration script:
changeDB.bat
- A Database Setup window will appear. Select MS SQL Server as the Server Type.
- Enter the Host Name of the new SQL server. The utility should automatically detect and list the available SQL Server instances.
- Select the correct Instance.
- Choose the appropriate Authentication method (Windows or SQL Server).
- Provide the necessary user credentials.
- Click Test to verify the connection to the new database.
- If the connection is successful, click Save. This will update the application's configuration files.
- Restart the ADSelfService Plus service.
Validation and confirmation
- Log in to the ADSelfService Plus admin and end-user portals.
- Verify that all data, reports, and configuration settings are present and correct.
- Perform a test password reset or account unlock to confirm that the application is fully functional with the new back-end database.
How to reach support
New to ADSelfService Plus?
Related Articles
How to migrate ADSelfService Plus with a Microsoft SQL backend database
Objective This article explains how to migrate the ADSelfService Plus application server to a new machine while retaining the existing external Microsoft SQL server database, ensuring minimal downtime, preserving custom configurations, and ...Migration from PostgreSQL database server to MS SQL
ADSelfService Plus comes bundled with a PostgreSQL database server to store basic user attributes and enrollment data. It also allows you to migrate from the built-in PostgreSQL to MS SQL. This guide will walk you through the database server ...Encryption and data storage in ADSelfService Plus database
Encryption in the ADSelfService Plus database ADSelfService Plus' database uses the following encryption methods to store sensitive data: Database Encryption method PostgreSQL AES-256-CBC Microsoft SQL AES-256-CBC The following sensitive information ...How to migrate ADSelfService Plus to a new server
Objective This article provides a comprehensive, step-by-step procedure for migrating the ADSelfService Plus installation from an old server to a new one. This process involves backing up the database and essential configuration files, and correctly ...Microsoft 365 password reset
The Self-Service Password Reset (SSPR) feature in Azure AD allows users to reset their passwords without going through the help desk. However, changes to users' Azure AD passwords are only synchronized with their on-premises domain accounts when ...