ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 50591

calendar_today

Updated On:

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:
Powered by Wolken Software