Reset the BO Administration Password

Issue: 

The password for the administrator password is lost and there is no other account with administrator rights to log in the CMC and reset the password for this user

Resolution:

warning: The following resolution involves modifying your installation and Central Management Server (CMS) database. Please take a full backup of your installation and CMS database before proceeding.

1.      Use the Central Configuration Manager (CCM) to stop the Server Intelligence Agent (SIA).

>> To launch the CCM, go to Programs > SAP Business Intelligence > SAP BusinessObjects BI Platform 4 > Central Configuration Manager. Once you have confirmed that the SIA has stopped, proceed to the next step.

2.      Open Properties of the SIA. Copy the entire command line.

ex: 

      -boot "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.bootstrap" -port "6410" -dbinfo "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.dbinfo" -noauditor -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -traceinipath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/conf/BO_trace.ini" -name "WINC93I1FL0ODI" -piddir "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/"

3.      Open a "Command Prompt" window, enter the full path to the CMS.exe, and paste in the contents from step 2.

ex: 

          "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\cms.exe" 

4.      Append -serverconsole switch to the command and press Enter. For example, note that the following command has -serverconsole appended:

"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\cms.exe" -boot "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.bootstrap" -port "6410" -dbinfo "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/win64_x64/_boe_WINC93I1FL0ODI.dbinfo" -noauditor -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -traceinipath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/conf/BO_trace.ini" -name "WINC93I1FL0ODI" -piddir "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/" -serverconsole

         The CMS is launched in serverconsole mode. You will be prompted when the CMS is ready to accept commands.

5.      Go to the following folder: <BOE_INSTALL_DIR>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dfo 

        The dfo folder contains a subfolder with a randomly generated name starting with dfo_.


      

6.      Copy the file named BusinessObjects_Administrator_dfo.xml from inside the dfo_ folder to the following folder: <BOE_INSTALL_DIR>\SAP BusinessObjects Enterprise XI 4.0\packages

7.      Enter the following query: 

        select si_id from ci_systemobjects where si_name='Administrator' Record the SI_ID for the object.
Tip: SI_ID should be 12.

8.      Delete the object by typing the following command: delete <ID_NUMBER>

ex: delete 12

9.      Verify that the objects have been deleted by re-entering the command from step 7: 

       select si_id from ci_systemobjects where si_name='Administrator'
No objects should be returned.

10.    Enter the following query: 

        select si_id from ci_systemobjects where si_name='BusinessObjects_Administrator_dfo.xml' One object should be returned. 


        Record the object's SI_ID number.

11.    Delete the object by entering the following command: delete <SI_ID>

12.    Type quit to exit.

13.    Use the CCM to start the SIA.

14.    Launch the CCM, go to Programs > SAP Business Intelligence > SAP BusinessObjects BI Platform 4 > Central Configuration Manager.


You can now log on to the administrator account without having to provide password (leave the "Password" field blank).