Clarity

  • Private Community

  • 1.  How To Reset CMC Administrator Password

    Posted May 22, 2014 01:00 PM

    HI All,

    I can't get into CMC with the administrator's log in. This a system I inherited and no one seems to know the password and the password for it in the password vault doesn't appear to be valid. I see in CSA under Reporting a user administrator and the password field. I've attempted to reset it to the password in our key vault, but that doesn't seem to change it.

    Is there a way to reset the administrator's password for CMC?

    Thanks in advance.

    Ken



  • 2.  RE: How To Reset CMC Administrator Password

    Posted May 23, 2014 02:50 AM

    Hi Ken,

    If you are on BusinessObjects XI Release 2, the following steps might work.

    1. Open the Crystal Configuration Manager (CCM).
    2. Stop the Central Management Server (CMS).
    3. Open the CMS database administrator application (for example: SQL server enterprise manager if you are using MS SQL2000).
    4. Run the following SQL statement on the CMS database.

    SELECT * FROM CMS_InfoObjects5 WHERE (ObjectID = 12)

    5. Delete the record that is returned.
    6. Restart the CMS server from the CCM. This will recreate the administrator account with a blank password.
    7. Log on to the Central Management Console (CMC) using Administrator as a user name and a blank password.
    8. Now you can set the password for the Administrator account by navigating to Home -> Users -> Administrator. Once you type the password you can also check the option "Password never expires" and then click "Update"

    This info is taken from this sap thread. Read it fully for more details.--->  Problems with password in CMC

    Thanks,

    Georgy

     



  • 3.  RE: How To Reset CMC Administrator Password

    Posted May 23, 2014 07:59 AM

    Thanks for the help Georgy. I'm not sure of the release level, but in the CMS_VersionInfo table:

    SubsystemNumber   BuildVersion
    6                              12.0.0
     
    and the table is CMS_InfoObjects6.
     
    Would the same procedure still apply?
     
    Thanks,
     
    Ken


  • 4.  RE: How To Reset CMC Administrator Password

    Posted May 23, 2014 08:27 AM

    Hi Ken,

    Did you go through all the discussions in the link I have shared above? I see that some users with CMS_InfoObjects6 are facing issues after deleting the record returned from the query. They are advised to contact support.

    So even if you are going to give this method a try, do backup CMS DB prior to doing this.

    Thanks,

    Georgy



  • 5.  RE: How To Reset CMC Administrator Password

    Posted May 23, 2014 08:43 AM

    Thanks Georgy,

    I hadn't read through the thread, sorry, but now that I have, it appears the only safe route is via support.

    Thanks,

    Ken