Community and Support

            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. 


            3. If the database is PGSQL, connect to it. 

            If the database is MSSQL, go to the SQL Management Studio.

            4. Click the Windows icon and select Command Prompt (Run as administrator).


            5. Go to [your drive]:ManageEngine\ServiceDesk\pgsql\bin and run 
            psql.exe -U postgres -p 65432 -d servicedesk -h 127.0.0.1

            6. Copy and paste the below query and press Enter.

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

            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 less than 9.3 execute the below query,

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

             If the version/build is later than 9.3 execute the below query,

             update AaaPassword set password='$2a$12$fZUC9IK8E/AwtCxMKnCfiu830qUyYB/JRhWpi2k1vgWLC6iLFAgxa', SALT='$2a$12$fZUC9IK8E/AwtCxMKnCfiu' where algorithm='bcrypt' and 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.



            Helpful?  
            Help us to make this article better
            2 2