When Business Objects is installed, there is a Business Objects Administrator user who is needed for many administration tasks. If the Administrator password is lost, it must be reset, but there is no option to do so from within Business Objects. However, the password is stored in the Business Objects repository database, so it can be deleted at the database level to make the password blank. After following this procedure, the Business Objects administrator can regain access and set the password properly. These instructions assume that you are a skilled administrator of Business Objects.
- Skill level:
Other People Are Reading
Things you need
- Disk space for a backup copy of the repository database
Copy the Business Objects environment to a development environment and test this procedure. If it works, then do it in the real Business Objects environment.
Take a backup of the repository database. The repository database must be restored if this procedure fails or destroys the repository. This step definitely must be done if the procedure is being run in the real Business Objects environment.
Stop Business Object's CMS service from the operating system.
Log into the database and connect to the Business Objects database. If needed, contact the database administrator for assistance with the database portion.
In the CMS_INFOOBJECTS5 table, delete the record with ObjectID 13 from the table.
Restart the CMS service from the operating system.
Log into Business Objects as Administrator with a blank password. Make sure everything is still working, including reports, after this procedure. If so, assign the Administrator password. If not, stop the CMS service and restore the repository database from the backup.
Tips and warnings
- This is a high-risk procedure since it involves changing the Administrator property in the repository. Make sure backup and restore procedures actually work.