INSTRUCTIONS HOW TO CHANGE SQL PASSWORD FOR DATABASE USED BY IMC

INSTRUCTIONS HOW TO CHANGE SQL PASSWORD FOR DATABASE USED BY IMC.

IMC is unable to recognise some non-alphanumeric characters in SQL database password, for example %. In this case, the IMC log will show the error ‘login failed’. It is necessary to modify the SQL password for IMC to gain full access to the SQL database.

-       Change SQL Password in SQL database

-       Use Deployment Monitoring Agent to modify SQL password used by IMC.

Full description of steps.

1. Change SQL password in SQL

Start -> Run-> cmd

 sqlcmd 

 sp_password @old = null, @new = '3commypwd1',  @loginame ='sa'

 go

quit

2. Click environment tab in Deployment Monitoring Agent and change password to new one.

3. Stop jserver process and then start it, Right click on jserver, select stop process, wait until the status is stopped, then start process