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

Article Id: 50591
Status: Published
Updated On: 14-02-2018 07:22
Legacy Id: TEC543385
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: