Migrating ADManager Plus database to a Microsoft SQL failover cluster instance

A Microsoft failover cluster instance (FCI) is a feature of SQL Server that provides high availability by running SQL Server in a clustered environment and ensures the reliability of your database infrastructure. If you want to migrate your existing ADManager Plus database to a FCI, follow the steps given below.

Steps to migrate ADManager Plus's database to Microsoft SQL failover clusters

1. Stop ADManager Plus.
2. Invoke (ADManager Plus Home)\bin\ChangeDB.bat in command prompt. Make sure that the user running the command prompt is same as the one running ADManager Plus.
3. A database configuration wizard will display. There, select the server type as Microsoft SQL and provide these details:
   • In the Host Name field, fill in the virtual IP or the host name of the failover cluster instance.
   • In the Port field, enter the port number of the failover cluster instance.
   • In the Database Name field, fill in the newly created database's name.
   

   Note: The name of the Microsoft SQL server instance has to be entered manually in case you have not chosen the Auto Discover option.

4. Select the Authentication type. If you have selected Windows Authentication, the credentials are automatically taken. If you have selected SQL Server Authentication, enter the corresponding synchronized credentials.

Note: If SQL Server Authentication is used to move the database, access and permissions to the Microsoft SQL instance are automatically provided. However, when Windows Authentication is used, access and permissions have to be granted, as explained here.

5. Click Test Connection to check whether the credentials are correct.
6. Click Save.

The migration procedure will start, and it will take a few minutes to complete. Once the migration is successful, you should see this screen:

Specifying the failover time for a database

A failover occurs when one node crashes or becomes unavailable, prompting the other node to take over automatically. For uninterrupted running of ADManager Plus databases, it's important to provide the time within which the secondary node must become the primary node.

To achieve this, provide the values (in seconds) for the DBConnectionRetryCount and DBConnectionRetryInterval parameters in the <ADManager Plus installation folder>\conf\product-config.xml file