on 02-05-2010 5:04 PM
I need to reset the Administrator password for a XI R2 CMS. I see this topic in help:
-
Symptom
How to reset the administrator user account password in BusinessObjects Enterprise XI3.1.
Resolution
1. Take the back up of the CMS repository tables as a precaution.
2. Open the Central Configuration Manager (CCM).
3. Stop the Server Intelligence Agent (SIA).
4. Run the following SQL statements on the CMS database:
5. DELETE FROM cms_infoobjects6 WHERE (ObjectID=12);
COMMIT;
6. This will delete a record that belongs to the "Administrator" account.
7. Restart #Server Intelligence Agent (SIA)# from the CCM. This will recreate the administrator account with a blank password.
8. Now you can log on to the Central Management Console (CMC) using Administrator as a user name and a blank password.
-
However, I've seen some mention elsewhere that this might affect permissions for existing objects?
Is there any risk to existing data if I follow the procedure described above?
This didn't work for me with 4.2. The Administrators password wasn'nt blank ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Steve,
All the Administrators Preferences and added permissions will be also be reset. This will reset the Administrators access to default factory / install level.
SAP NOTE below for more details:
http://service.sap.com/sap/support/notes/1679970
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Editing the raw data in the CMS DB has never been officially supported although some DB hacks do exist such as deleting row 12. These workflows are not tested in BO and can produce unpredictable results (thus unsupported). That being said I have not heard of any issues with permissions.
Regards,
Tim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
i never tried this, but if the Administrator gets re- created he will get another ID in the system and than i could imagine that Security for the Administrator account is lost. Security f.e. like access to reports, folders etc.
Best would be creating a Message at SAP Support for assistance.
Regards
-Seb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.