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