Reset asministrator password for BO

[Former Member]

Dear All,

We have a problem here, where no one knows the administrator password to login to CMS. Below is the completed configuration on our system:

OS : Windows 2008 Ent.

BO: BussinessObjects XI 3.1

DB : mySQL

Any idea on how we reset the password at DB? or is there any way for us to reset the pwd.

Thanks in advance.

[Former Member]

Resolved

[atul_chowdhury2]

Make Absolutely Sure You Backup Your CMS DB

- Stop theCMS

Using your MySQL command line:

  delete from CMS_INFOOBJECTS6 where OBJECTID = 12

Start the CMS

...your Administrator password for login will now be empty/blank/nothing ...

Hope this helps

[Former Member]

Dear Atul Chowdhury,

Thank for your reply.

Does coping the BusinessObject folder in C drive considered as backup?

Sorry im not sure how else to backup the mysql server. Kindly advice.

[Former Member]

Backing up the BusinessObjects folder is not enough. You need to talk to your network admin and your DBA to do synchronized backup of the Input/Output FRS and the system database.

[former_member136842]

Hi,

or check this Guide:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0020482-ca8d-2c10-9bad-d1bd332bb...

Regards

-Seb.