Orion NPM 10.6 reset admin password?

Hello,

Backup db and

1. Delete from accounts where  where AccountID = 'Admin'

2. Run configuration wizard.

3. Admin account should be recreated with blank password.

Alternatively you can do the below if you don;t want to re-run the config wizard:

1. Open the Orion Database Manager (Start -> All Programs -> SolarWinds Orion Advanced Features)

2. Connect to your DB server (if not on the list please add it with relevant credentials)

3. Expand your database

4. Right click on ANY table and select Query Table

5. Overwrite existing query with following, click on Refresh button EngineID

SELECT AccountID, Password

FROM Accounts

WHERE AccountEnabled = 'Y'
 

6 . You will see list of ALL active accounts with their encrypted passwords. If you do not see  any user accounts from this query then your account is disabled and you can enable it with the following :
 

UPDATE Accounts

SET AccountEnabled = 'Y'

WHERE AccountID = 'admin'

7. Overwrite existing query again with the following :

UPDATE Accounts

SET Password = ''

WHERE AccountID = 'admin'

8 .Click on Refresh button

There will be no results shown so in order to see if password was set to "blank" execute query from step 5. again. At this stage you should be able to login to your Web console and modify password.

For anyone trying to do this with NPM t1.0.1 and greater, the Accounts table has changed and so ederdal‌'s method will not work.  You can use LadaVarga‌'s but after you run the config wizard you have to modify the HomePageViewID and SummaryViewID fields to views configured on your system.    You can use the SolarWinds Database Manager utility to do this by clicking the "Enable table editing" option.

Is this method valid for NPM 12.3?

I am in big trouble, we can´t access to the web console.

Anyone tried this method with 12.3 version?

Thanks.

https://support.solarwinds.com/Success_Center/Orion_Platform/Knowledgebase_Articles/Restore_password_for_an_Orion_Web_Co…

It works for NPM 12.2!!!