Knowledge Article
Remedy AR System Server - How to change ARAdmin database user password in Remedy - INCLUDES VIDEO
Remedy AR System Server - How to change ARAdmin database user password in Remedy - INCLUDES VIDEO
Remedy AR System Server
AR System
AR system server version 7.x, 8.x, 9.x and higher version
If a new password is set in the Server Information > Database will it change in database? and/or: If the password is changed in the database, how to change it in Remedy? |
VIDEO STEPS Question: If a new password is set in the Server Information > Database (tab) will it change in database? Answer: No, the password is changed at the application level. It should also be changed in database as well. Question: If the password is changed in the database, how do you change it in Remedy? --- Note --- Changing the password for the user ARADMIN (default) in the database it is something under the DBA team's scope. The following can be done in the Database to change the password for the ARAdmin database user Oracle database, issue the following SQL statement when logged in as user system: ALTER USER "ARADMIN" IDENTIFIED BY "AR#Admin#"; MSSQL database, issue the following SQL statement when logged into Query Analyser as sa: sp_password 'oldpassword', 'AR#Admin#', 'ARAdmin'; (please check with the DBA Team to perform the above to be sure it is done correctly). Answer: A) If ARSystem is already running after having changed the Database password by the DBA team, follow these steps: 1- Login into Remedy and go to Applications > AR System Administration > AR System Administration Console > System > General > Server information 2- Open the Database tab: 3- Enter the new Database password in the Database Password field which is blank. 4- Click Apply. Once the password is applied the field again becomes blank. 5- Restart ARSystem to take this into effect. B) If ARSystem is NOT running after having changed the Database password by the DBA team, follow these steps: 1- Open the ar.cfg/ar.conf file and remove the encrypted password of the parameter Db-password: Example: - From: Db-password: UArtBHLPCHNXiD0LmfkZBJn8giOqCZw+2F29XsS8/byvlFEWsUsXvgXzbheVVcN+X6Y2r3vWCFhD1C6vENasPZ2KHCylte4buAVak6CwvbYZOUZpIorefw== - To: Db-password: 2- Type the new password in plain text on this parameter. For this example we will use the default password: AR#Admin# Example: - From: Db-password: - To: Db-password: AR#Admin# 3- Start ARSystem. 4- Once ARSystem is up and running the new password set in the previous step needs to be encrypted. To do so, follow these steps: a) Backup the ar.cfg/ar.conf file. b) Login into Remedy and go to Applications > AR System Administration > AR System Administration Console > System > General > Server information c) Open the Database tab. d) Enter the new password in the Database Password field which will be blank. e) Click Apply. Once the password is applied the field again becomes blank. f) Restart ARSystem and the application will encrypt the password. This can be checked by looking at the current ar.cfg/ar.conf file ( Db-password ). Related Information: Remedy - Server - Error:"ORA-28000: the account is locked" after changing the password to the database for the Oracle Account ARAdmin and AR Server is not starting up Remedy - Server - ARSystem 9.1.03 installer throws the error: "ORA-01017: invalid username/password; logon denied" |
Attachment(s):