How to identify and login to CMC schema when Admin UN/PW is locked/Forgotten

[Former Member]

Hi all,

   I am facing an issue while logging into CMS/any module with Administrator credentials ,I feel that password is wrong.

Now i have to reset the Administrator password .

I read in many discussions that it has to be changed/deleted by logging into CMC schema as mentioned in below discussion

But am unable to login to any module , Kindly let me know how to identify the CMC schema details and can i use SQL Developer/Toad to connect to this schema and perform the delete operation.

BO version : XI R3 SP4

OS : Windows 2000 server

Thanks in advance

Arjun

[former_member230417]

Hi Arjun,

Follow the below SAP Note:

1320151 - How to reset Administrator account password in BusinessObjects Enterprise XI 3.1

Yes you can use Toad or any other client to connect to your Database and fire the below SQL Query.

**********MAKE SURE YOU TAKE A BACKUP OF CMS DB*******************

Resolution

--Take the back up of the CMS repository tables as a precaution.

--Open the Central Configuration Manager (CCM).

--Stop the Server Intelligence Agent (SIA).

--Run the following SQL statements on the CMS database:

DELETE FROM cms_infoobjects6 WHERE (ObjectID=12);

COMMIT;

This will delete a record that belongs to the "Administrator" account.

Restart “Server Intelligence Agent (SIA)” from the CCM. This will recreate the administrator account with a blank password.

Now you can log on to the Central Management Console (CMC) using Administrator as a user name and a blank password.

Regards,

Nachiket