How do you change the SQL password for AppManager NetIQ account? (NETIQKB2523)

How do I update the login used by the Management Server service and the NetIQ SQL account password?

In some instances, you may be required to reset or change the NetIQ SQL account password within the repository (QDB by default).  This applies if your SQL server is using Standard or Mixed security. If you are using Integrated (Windows NT only) security, refer to Microsoft documentation on changing passwords and configuring Windows NT user accounts to SQL user accounts.

To reset the NetIQ SQL account password:

1. Stop the NetIQms service.
2. Open SQL Enterprise Manager or SQL Management Studio and expand to Security | Logins.
3. Right-click the NetIQ account and select Properties to reset the password.
4. Update the login used by the Management Server service.
   
   • Run the following command at a command prompt to re-register the MS service. You can use -ur to retain your security\encryption settings.
     
     netiqms -r QDBMS:QDB:netiq:[new netiq password]:[QDB server name]-i

The command may return a "installed DSN QDBMS" message or just return to the prompt. In either event, restart the NetIQms service.

Formerly known as NETIQKB2523