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.
New to ADSelfService Plus?
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 Applications Manager's home directory in the command prompt and run the below commands one by one: For Windows ...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 ...Installing Applications Manager in Microsoft Azure
Applications manager can be installed in Azure Virtual Machines in both Windows and Linux platforms. Applications Manager comes with bundled PostgreSQL. Installing Applications Manager in VM for Windows Go to Virtual Machines and create a "Windows" ...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 ...