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.
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).
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.
Make a backup of your CME database
Stop Configuration Server
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;
Start Configuration Server.
This will change the password to ‘password’.
NOTE:
Don’t put the password of your own instead of ‘5F4DCC3B5AA765D61D8327DEB882CF99’.
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.