Change Default config manager password

[nomster123]

due to a stupid mistake i changed password of default by mistake and unable to login to my config manager, im using SQL server 2008 with Conf server 8.1, tried to delete the password from cfg_person but it still doesnt log in as it is uding its own encryption. If i even delete the password entry it still doesnt log in. Suppose there is exncrypted for empty string too.

Please help its very important

[cavagnaro]

You will have to delete password on sql table and restart CfgServer after that.

Enviado de meu C6602 usando Tapatalk

[nomster123]

Deleted password and restarted DB server and CFG server but no use. its not accepting blank password

[cavagnaro]

Then create a password on another account you know. Copy the encrypted value to the default account and done. Easy as that...

Enviado de meu C6602 usando Tapatalk

[nomster123]

Problem is that there is only one account in the DB right now that is default. Havant added any agent yet :/

[Adam G]

Re-install?

[Kubig]

Just idea : Try to extract just the SQL script for cfg_person table from the SQL scripts for the CFG databse and recreate this table (the default user should be create with default password).

[nomster123]

dont want to reinstall, have already installed alot of things in it

@kubig: ill try this and get back to you on this

[nomster123]

Kubig , I am having trouble finding exact SQL statement which will insert  into persons table, There were two scripts i used , one was init other was CFG locals but both contain a lot of commands, it might just affect the whole Table.

Can you please specify which commands from these two scipts. Forgive me knowledge of SQL. Using SQL Server

[raza990]

Please follow below steps if you forget the password of configuration server.

1. Make a backup of your CME database
2. Stop Configuration Server
3. Run this SQL query against the database:
a. Pre 8.0.3 configuration server/db:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' WHERE dbid=100;
b. 8.0.3 config server or highter:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' , salted_string=NULL WHERE dbid=100;
4. Start Configuration Server.

This will change the password to 'password'.

NOTE:
Don’t put the password of your own instead of '5F4DCC3B5AA765D61D8327DEB882CF99'.

[Adam G]

Good post.

Wonder if there is a way on SMF to flag it, as "useful"?


[quote author=raza990 link=topic=9084.msg40723#msg40723 date=1441611300]
Please follow below steps if you forget the password of configuration server.

1. Make a backup of your CME database
2. Stop Configuration Server
3. Run this SQL query against the database:
a. Pre 8.0.3 configuration server/db:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' WHERE dbid=100;
b. 8.0.3 config server or highter:
UPDATE cfg_person SET password='5F4DCC3B5AA765D61D8327DEB882CF99' , salted_string=NULL WHERE dbid=100;
4. Start Configuration Server.

This will change the password to 'password'.

NOTE:
Don’t put the password of your own instead of '5F4DCC3B5AA765D61D8327DEB882CF99'.
[/quote]

[orel]

Hello,

I am trying to to compute the correct hash with a given password and salt.
The documentation states that this should be sha256(clear_text_password || salt) or sha256(salt || clear_text_password) but this doesn't seem to work.