Moderator note:
Attention: The article below corresponds to SAP BusinessObjects Enterprise XI 3.1. Do not follow the below solution on SAP BusinessObjects Business Intelligence Platform 4.x.
For resetting the administrator password on 4.x versions please see one of the below KBAs depending on your OS type:
1679970 - How to reset the Administrator password in Business Intelligence platform 4.x
1719361 - How to reset/recreate Enterprise 'Administrator' account in BI 4.x on Unix
This is a re-post of an old entry I made years ago in a company blog. That blog is no longer active, so I have re-posted it here to maintain an archive of my own old blog entries
Note: |
---|
The approach going forward is more or less the same, if you where using Oracle. If you are using the "built-in" MySQL or Sybase SQLAnywhere, then you will need to have the root password to access the tables in these types of databases. First locate the table CMS_InfoObjects6 in your BusinessObjects CMS database, but the data in the table is encrypted and not in clear text, so you can not read nor simply write a new password in here. |
Disclaimer: |
---|
At this point I must emphasize that anything you do, you do at your own risk. Before you delete any data in the database, make sure you do have a proper backup. Neither I or Infotrust will not be held liable for any damage of data loss. So simply, open the table CMS_InfoObjects6, and delete the record with ObjectID 6, since this is the default ID for the Administrator account. If you don't believe me, try look up the ID for the Administrator account on your system |
DELETE FROM dbo.CMS_InfoObjects6 WHERE ObjectID = 6
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |