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 :ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command:
psql -h localhost -U sdpadmin -p 65432 -d servicedesk
Enter password sdp@123 when prompted.(Default Password)
To Fetch Active SDAdmin:
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 'SDOrgAdmin' and sd.status='ACTIVE';
From the result, select the user and use their login_id in the below query to reset the password.
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 IN RUNNING STATE WHILE EXECUTING THE ABOVE QUERY
From the result, select the user and use their login_id in the below query to reset the password.
New to ADSelfService Plus?
Related Articles
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 ...Customize password reset email
Steps to customize the email sent for resetting the password of a technician or requester Follow the below steps to customize the password reset link email content: 1. Admin -> Settings -> General settings -> translations 2. In the search bar enter ...Best Practices to Secure the application (ServiceDesk Plus - MSP & Supportcenter Plus)
This document is common for ServiceDesk Plus MSP and Supportcenter Plus application Best practices to avoid threats: Upgrade to the latest version and builds. Reset the password of bundled accounts (administrator and guest) Enable two-factor ...How do I host ServiceDesk Plus MSP on the internet?
In order to make ServiceDeskPlus – MSP available for users in Internet, let us assume the following scenarios. Scenario 1: ServiceDesk Plus – MSP is installed in LAN and should be available in LAN and WAN: Assume ServiceDesk Plus – MSP is installed ...Forgot password option missing
If Forgot password option missing in the login page, then please check the below option under Admin->Self-Service Portal Settings. If this option is disabled, then the Forgot password option will not be visible in the login page. Allow users to login ...