Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
Situation
How do I update the login used by the Management Server service and the NetIQ SQL account password?
Resolution
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:
- Stop the NetIQms service.
- Open SQL Enterprise Manager or SQL Management Studio and expand to Security | Logins.
- Right-click the NetIQ account and select Properties to reset the password.
- 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
- Run the following command at a command prompt to re-register the MS service. You can use -ur to retain your security\encryption settings.
The command may return a "installed DSN QDBMS" message or just return to the prompt. In either event, restart the NetIQms service.
Additional Information
Formerly known as NETIQKB2523