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
- If you are not using windows authentication then 'domain=domainname' is not required.
- If you are not connecting to a named MS SQL instance then 'instance=instancename' is not required.
- 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 ADSelfService Plus?
Related Articles
Integrating Applications Manager DB with Grafana
Grafana is an open-source data visualization tool that collects data across multiple software platforms and retrieves them altogether in a single dashboard. It provides advanced analytics by connecting to various data sources in different platforms, ...How do I migrate Applications Manager installed in one machine to a different machine?
Migrating Professional Edition of Applications Manager In order to migrate Applications Manager and its contents to a new machine, you need to ensure that the version of Applications Manager you install in the new machine matches that of the old ...How is Backup Age calculated for MS SQL DB monitor?
Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...Issues while installing or starting Applications Manager with Microsoft SQL Server backend database
Problem: Unable to install or start Applications Manager using Microsoft SQL Server database as backend. Solution: Follow the below troubleshooting steps to resolve the issue: 1. On the Microsoft SQL server host, go to Start -> All Programs -> ...Enabling Kerberos Authentication for SQL Server in Applications Manager
I. How to implement Kerberos Authentication for Applications Manager's MS SQL Back-End Database? 1. Stop Applications Manager service. Open Applications Manager's home directory in the command prompt and run the below commands one by one: For Windows ...