After a new ITCM installation, the following error occurs while opening the DSM Explorer: "User does not have view permission on the object (CMM000249)"

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Server Automation
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

After a new ITCM 12.5 installation, the following error occurs while opening the DSM Explorer:

User does not have view permission on the object (CMM000249)

This can happen if the CHECK_POLICY and CHECK_EXPIRATION options were turned on while installing SQL Server 2005. (These options are turned on by default)

Solution:

Run the following SQL statements against the mdb:

ALTER LOGIN [ca_itrm] WITH PASSWORD='NOT_changedR11',DEFAULT_DATABASE=[mdb],DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFFGO

Environment

Release: UASIT.99000-12.5-Asset Intelligence
Component: