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

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

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