How to reset the Local Admin Password ? (Used in cases where your Domain controller goes down and if you are unable to login to the application with your domain credentials)

Follow the steps as mentioned below which would help you to reset the administrator account password as “admin”.

For the database is MYSQL,

 

1. Connect to MYSQL Server on Port 33366 using the command from the SD+ server console.

cmd > cd [SERVICEDESK PLUS MSP Home]\mysql\bin
cmd> mysql.exe -u root -P 33366 servicedeskTo find Administrator logins execute below query:
select aar.account_id,al.name from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id left join aaaaccount aa on aar.account_id=aa.account_id left join aaalogin al on aa.login_id=al.login_id left join aaauser au on al.user_id=au.user_id left join sduser sd on au.user_id=sd.userid where aar.role_id=4 and sd.status=’ACTIVE’; 

2. Use the below query to reset the “admin” account password, instead of username at the end of this query you have to enter the username of the account for which you would like to reset the password.

 

update AaaPassword join AaaAccPassword on AaaPassword.password_id = AaaAccPassword.password_id join AaaAccount on AaaAccPassword.account_id = AaaAccount.account_id join AaaLogin on AaaAccount.login_id = AaaLogin.login_id set PASSWORD=’2+uYvE3SLfO3XaHl+CaGLA==’, SALT=’1103287238602′ where name=’username‘; 

To execute lengthy queries, copy the query in a file <query.txt> and execute the query as below in command line.
 
mysql -u root -P 33366 servicedesk < query.txt
 
The above command will execute the query. It will show the result in console only for select queries. For update queries no output will shown in the console.
If the database is MS SQL,
To find Administrator logins execute below query:
select aar.account_id,al.name from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id left join aaaaccount aa on aar.account_id=aa.account_id left join aaalogin al on aa.login_id=al.login_id left join aaauser au on al.user_id=au.user_id left join sduser sd on au.user_id=sd.userid where aar.role_id=4 and sd.status=’ACTIVE’;
Use the below query to reset the “admin” account password,instead of username at the end of this query you have to enter the username of the user for whom you would like to reset the password.
update AaaPassword set PASSWORD=’2+uYvE3SLfO3XaHl+CaGLA==’, SALT=’1103287238602′ where PASSWORD_ID in ( select AaaPassword.PASSWORD_ID from AaaPassword LEFT join AaaAccPassword on AaaPassword.password_id = AaaAccPassword.password_id LEFT join AaaAccount on AaaAccPassword.account_id = AaaAccount.account_id LEFT join AaaLogin on AaaAccount.login_id = AaaLogin.login_id where name = ‘username’ )The first query lists out admin accounts and from the second you can reset the password for any of these accounts.
After resetting the password you will be able to login with password as ‘admin’, provided you select ‘localauthentication’ in the logonto dropdown list.

Note:
 For MSSQL connect to the query analyzer of the SQL server and execute the same queries.
 
PGSQL

Navigate into 
cmd > cd [SERVICEDESK PLUS MSP Home]\pgsql\bin and executepsql -h localhost -p 65432 -U postgres -d servicedesk
1.) Execute this query to find all the Administrator logins in the application.
select al.login_id”Login ID”,au.first_name”Name”,al.name”Login Name” from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id left join aaaaccount aa on aar.account_id=aa.account_id left join aaalogin al on aa.login_id=al.login_id left join aaauser au on al.user_id=au.user_id left join sduser sd on au.user_id=sd.userid where aar.role_id=4 and sd.status=’ACTIVE’;

2.) From the output of the first query, identify the right user and use the login_id for that user in the below query(where it is highlighted) to reset his password. 

 

update AaaPassword set password=’2+uYvE3SLfO3XaHl+CaGLA==’, SALT=’1103287238602′ where password_id in (select ap.password_id from aaaaccpassword ap left join aaaaccount ac on ac.account_id=ap.account_id left join aaalogin al on al.login_id=ac.login_id where al.login_id=LOGIN_ID);
Note:
After resetting the password, you will be able to login with password as ‘admin‘, provided you select ‘Local Authentication’ in the “Log on to” drop-down list.

 

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500