How to reset administrator password in ServiceDesk Plus (or Asset Explorer).
1. Access your application server and browse to [your drive]:\ManageEngine\<application_name>\bin.
2. Click
changeDBServer.bat.
Information on the configured database will be displayed.
If the database is MSSQL, go to the SQL Management Studio, go to the 6th step.
3. If the database is
PGSQL
, connect to it.
4. Click the Windows icon and select
Command Prompt (Run as administrator).
5. Go to [your drive]:ManageEngine\<spplication_name>\pgsql\bin and run
If SDP versions less than 10.5/ AE version less than 6.5:
psql.exe -U postgres -p 65432 -d servicedesk -h 127.0.0.1
If SDP versions greater than 10.5/ AE version greater than 6.5:
psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1
Enter password sdp@123 when prompted.
6. Copy and paste the below query and run it to Fetch Active SDOrgAdmin after SDP 11.0 / AE 6.6 (See below for older versions)
Select al.login_id"Login ID",au.first_name"Name",al.name"Login Name", al.domainname"Domain 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 ar.name like 'SDOrgAdmin' and sd.status='ACTIVE';
7. From the result, select the user and use their login_id in the below query to reset their password after SDP 10.5 / AE 6.5 (See below for older versions)
PGSQL:
update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT=pgp_sym_encrypt('$2a$12$fZUC9IK8E/AwtCxMKnCfiu','SChar@123Mas!er','s2k-mode=1, cipher-algo=aes256'), algorithm='bcrypt' 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);
MSSQL:
OPEN SYMMETRIC KEY ZOHO_SYMM_KEY DECRYPTION BY CERTIFICATE ZOHO_CERT;update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT= EncryptByKey(Key_GUID('ZOHO_SYMM_KEY'), N'$2a$12$fZUC9IK8E/AwtCxMKnCfiu'), algorithm='bcrypt' 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);CLOSE SYMMETRIC KEY ZOHO_SYMM_KEY ;
NOTE FOR MSSQL: Application should be running while executing the above query
After resetting the password, you will be able to log in with password as 'admin'. Ensure that you have selected 'Local Authentication' in the "Log on to" drop-down list. If the user has any domain, choose the domain in the next dropdown (if the dropdown is visible)Note: For SDP, if Local Authentication is disabled in the application, please execute the query below in the database and restart SDP service. For AE, this entry does not exist and we allow local authentication by default (unless customer has inserted this entry with the value 'false').
update globalconfig set paramvalue='true' where parameter='Enable_LocalAuthentication_Login';For Older Versions:
Step 6:
To Fetch Active SDAdmin (before SDP 11.0 / AE 6.6 )
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 ar.name like 'SDAdmin' and sd.status='ACTIVE';Step 7:
If the version/build is less than SDP 10.5 / AE 6.5 execute the below query:
update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu', algorithm='bcrypt' 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);If the version/build is less than SDP 9.3 / AE 6.2 execute the below query:
update AaaPassword set password='2+uYvE3SLfO3XaHl+CaGLA==', SALT='1103287238602', algorithm='MD5' 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);
New to ADSelfService Plus?
Related Articles
Script to reset password and enable local authentication
Purpose : Interactive mode of resetting the password of a user by entering his username. Also, to enable local authentication in the application. This script can be used in builds on or above 9400 version How the script works ? Invoking the script ...Script to reset the password of a user by entering his username and enable local authentication without connecting to DB.
Script to reset the password of a user by entering his username. Also, to enable local authentication in the application without connecting to DB. How the script works ? Invoking the script will show two options. 1. Enable local authentication in the ...How to reset Admin password (SDOrg) for SupportCenter Plus 11.0 version and above
This is applicable only above SupportCenter Plus 11.0 version. If you are using any other build , please contact support with the details. You can get the build number from About us present in the top right of the user interface. 1. Access your ...How to reset administrator password in ServiceDesk Plus MSP
Follow the below steps to reset Administrator password for builds more than 10600 (To reset the password for less than 10600. Please contact support. ) 1.Connect to the DB Server. i) For MS-SQL-Connect to the MS-SQL Server ii) For Postgres, go to ...8.1 Reset global admin Password from the database
MYSQL query to reset Administrator's password: Follow the steps as mentioned below which would help you to reset the "admin"/"administrator" password as "admin". 1. Connect to MySQL Server on Port 33356 using the command from the SC+ server ...