Description:
When opening the web console 'inventory tab' the following error occurs:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'ca_itrm'.".
Solution:
The above error occurs, if the password for ca_itrm account has been changed from the default.
The new password needs to be configured with the following command:
cadsmcmd setDBCredentials passwd=<new passwd>
Also update the ams.properties file in WAC, with the new password:
sqlserver.password=<new password>