Change Default config manager password

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

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

Enviado de meu C6602 usando Tapatalk

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

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

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

Re-install?

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).

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

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

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

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’.

Good post.

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

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.