| | | |
 Uploading ....How do I migrate the MSSQL DB used by our Applications Manager to another MSSQL server?
- Shutdown Applications Manager completely before the database migration.
Stop Applications Manager services.
Shutdown AppManager via command prompt by executing the following command from <APM_Home> folder:
shutdownApplicationsManager.bat -force (<APM_Home>
is the directory in which Applications Manager is installed, default
location is C:\Program Files (x86)\ManageEngine\AppManager10)
Repeat the same until you find the message "No processes related to the Applications Manager are Running"
- Migrate the database to new server.
For steps and tips for migrating MsSQL to a new server refer below link.
http://support.microsoft.com/kb/314546
- Configuring Applciations Manager to work with the database in new server
I. Open WordPad and edit the database_params.conf file present in "<APM_home>\working\conf\MSSQL\" and "<APM_home>\working\conf\" and change the hostname , port , domain , instance name in the below line as applicable.
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.
url jdbc:jtds:sqlserver://hostname:1433/AMDB;domain=domainname;instance=instancename;appName=ApplicationsManager
AppModules
TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
II. Change the username to connect to the MS SQL server (if it has been changed) in the same file in the below line
username monitoruser AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
III. Change the password to connect to the MS SQL server (if it has been changed) in the same file in the below line. To change the password change the word encryptedpassword as password & leave a space & then type the password in clear text. During next restart of the product password will be encrypted automatically.
encryptedpassword eK6q1CJ9697s7O AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB
Save and close the file.
Note: Take backup of the existing files before any modifications.
- 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 below link
https://apm.manageengine.com/unable-to-install-apmanager-using-mssqlserver-as-backend-database.html
|
|
|
| | | |
|
