Modify mssql server details currently used in applications manager

Modify mssql server details currently used in applications manager

Steps to change the Microsoft SQL Server details like hostname , port , username & password that are currently used in Applications Manager

1. 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

2. 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

3. 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

change this line as follows, assuming apm@123 is correct password for the user

password apm@123 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB

Save and close the file.

Note: Take backup of the existing files before any modifications.
          • Related Articles

          • 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 AppManager Home directory in command prompt and run the below commands one by one.             If ...
          • How to enable Kerberos Authentication for Applications Manager's MS SQL backend database?

            Follow the steps given below to enable Kerberos authentication for MS SQL backend database: 1. Stop Applications Manager service. Open Applications Manager Home directory in command prompt and run the below commands one by one.             For ...
          • Authentication Methods in Applications Manager

            Authentication involves validating an incoming user to facilitate the access to a specific resource. There are various authentication methods that you can use - based on the requirements and usage. In recent times, numerous organizations are ...
          • Installing Applications Manager in AWS

            Applications manager can be installed in EC2 instances in both Windows and Linux platforms. Applications Manager comes with bundled PostgreSQL. Installing in EC2 - Windows Go to EC2 console and launch an "Windows" instance with "Atleast 16GB" memory. ...
          • Maintenance of Applications Manager

            Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...