Errors "Error SME_APP_DEFINED_0B Application defined error code (11/0B) [CMM208955]" and "Error connecting to database [CMM000025]"

Document ID : KB000027197
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

When trying to open the SDM GUI the following message is displayed:

"Error SME_APP_DEFINED_0B Application defined error code (11/0B) [CMM208955]"

Additionally, the following message may be displayed:

"Error connecting to database [CMM000025]"

Environment:  

All Supported version of CA Client Automation running the DSM Explorer.
All Supported versions of Microsoft SQL Server. 

Cause: 

The above error(s) occurs when there is problem with the ca_itrm users password ; which is used to connect to the mdb database.

 

Resolution:

Verify if you can login using the ca_itrm user and password using MSSQL if you can not then follow these steps:

SQL Server on Windows Server

  1. Reset the password in SQL Server:

    Open SQL Server Enterprise Manager
    Chose Security\Logins
    Double click on the ca_itrm user and reset the password

    Note: The default password at installation is NOT_changedR11

  2. Reset the password for ca_itrm in comstore:

    Open a DOS prompt and enter the following command:

    cadsmcmd setdbcredentials passwd=<password entered in step 1>

 

Additional Information:

For more information on the supported versions of CA Client Automation or Microsoft SQL please review the compatibility matrix at this link:

https://support.ca.com/irj/portal/anonymous/phpsupcontent?contentID={5388D4CA-E235-4113-9EE5-CC5C038AB99E}