How do I migrate the MS SQL DB used by Applications Manager to another MS SQL server?

How do I migrate the MS SQL DB used by Applications Manager to another MS SQL server?

Follow the steps given below to migrate MS SQL database of Applications Manager to another MS SQL server:

1. Shutdown Applications Manager completely before the database migration.
a. Stop Applications Manager service.
b. Shutdown Applications Manager via command prompt by executing the following command from <Applications Manager Home> folder: shutdownApplicationsManager.bat -force 
c. Repeat the same until you find the message "No processes related to the Applications Manager are Running"

2. Migrate the database to the new server.
For steps and tips for migrating MS SQL to a new server, refer the following link: http://support.microsoft.com/kb/314546

3. Configuring Applications Manager to work with the database in new server.
a. Open notepad and edit the database_params.conf file present in both <Applications Manager Home>\working\conf\MSSQL\ and <Applications Manager Home>\working\conf\ directories and change the hostname, port, domain, instance name in the below line as applicable:
url jdbc:jtds:sqlserver://hostname:1433/AMDB;domain=domainname;instance=instancename;appName=ApplicationsManager AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

  1. If you are not using windows authentication then 'domain=domainname' is not required.
  2. If you are not connecting to a named MS SQL instance then 'instance=instancename' is not required.
  3. By default, AMDB is the database name. If you have renamed or going to use a different database then you can enter appropriate database name, otherwise do not modify it.
b. Change the username to connect to the MS SQL server (if it has been changed) in the same file in the following line:
username monitoruser AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

c. Change the password to connect to the MS SQL server (if it has been changed) in the same file in the following line:
encryptedpassword eK6q1CJ9697s7O AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

To change the password, change the word encryptedpassword as password, then leave a space and then type the password in clear text. During next restart of the product password will be encrypted automatically.

d. Save and close the file.
Note: Take backup of the existing files before any modifications.

 4. Start Applications Manager.

Check if it is connected to the database on the new server. If you need any assistance or face any issues while migrating contact appmanager-support@manageengine.com along details in the following link: https://pitstop.manageengine.com/portal/en/kb/articles/i-am-unable-to-install-or-start-the-applications-manager-using-microsoft-sql-server-database-as-backend

                New to ADManager Plus?

                  New to ADSelfService Plus?