How to reset administrator password in ServiceDesk Plus.

How to reset administrator password in ServiceDesk Plus.



1. Access your ServiceDesk Plus server and browse to [your drive]:\ManageEngine\ServiceDesk\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\ServiceDesk\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 press Enter.

To Fetch Active SDOrgAdmin (after
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 'SDOrgAdmin' and sd.status='ACTIVE';


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';
7. From the result, select the user and use their login_id in the below query to reset the password.
If the version/build is or greater than SDP 10.5 / AE 6.5 execute the below query:

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
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);

 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. 

8. If Local Authentication is disabled in the application, execute the query below in the database to enable it.
update globalconfig set paramvalue='true' where parameter='Enable_LocalAuthentication_Login';


9. Restart ServiceDesk Plus once after executing the above query.

          • Related Articles

          • How to configuring Pass-Through Authentication ( SSO) in ServiceDesk Plus ?

            Note: If the login page is customized, Pass-Through authentication will not work as it can't make use of the session variables set in login.jsp file The following instructions will help you to configure Pass-through authentication under Admin – ...
          • How to integrate ServiceDesk Plus with OpManager

            Log in to ServiceDesk Plus. 1. Go to Admin>>General Settings >>ME Integrations. 2. Click on OpManager. 3. Provide the OpManager server name, port number, and protocol information. 4. Click Test Connection and Save. Log in to OpManager. 1. Go to Basic ...
          • Password Reset for a user account in ADMP

            Use Case:  Frequent calls to the help desk to reset their account password, are quite common. This process entails redundant work, its time consuming. This can be automated with ServiceDesk Plus’ in-product capabilities. Making use of the DRE in ...
          • Applying mail server's certificate in ServiceDesk Plus

            To establish a secure connection between ServiceDesk Plus and email servers configured with a self-signed certificate, follow these steps: 1. Download the attached file. 2. Extract the files to the ServiceDesk Plus directory. 3. The files will now be ...
          • How to forward a request from one Servicedesk Plus instance to another.

            This is a Sample Python Script which can be used to get Data from a Existing Request in a ServiceDesk Plus instance and create a New Request in a parallel ServiceDesk Plus installation.  This script can be configured under Request Custom Menu if the ...