I have just (well yesterday) installed the latest version of ServiceDesk Plus; and it is setup as the trial version.
I am in the process of setting this up so i have created a new admin account called admin.
I deleted all the other admin accounts.
Connected my AD to ServiceDesk and sync'ed the users; i rebooted the server and i was able to log in using my admin account without any issues.
So like i said i did a lot more of the config of ServiceDesk, and logged out last night.
This morning, i am not able to log in using my admin account, all i get is unknown user or wrong password type of message.
After checking google i found your information on resetting the admin account.
I am using the buildin PGSQL database server
I did the following (after going to the pgsql bin folder)
psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1
(logged in using sdp@123)
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';
this give the output of
Login ID | Name | Login Name
----------+-------+------------
312 | Admin | admin
(1 row)
i then did
pdate 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=312);
which gives the output as
UPDATE 1
I tied to login and i am getting the same error
I tried rebooting and still the same
When i try and log in i get the option of "Not in Domain" or the name of my domain
I then redid the above and also did this command
update globalconfig set paramvalue='true' where parameter='Enable_LocalAuthentication_Login';
after a reboot i am still getting the same issues
Any ideas to what to try next? as i dont want to uninstall and reinstall and restart all of the config as it took 4 hours yesterday to do (and yes i did all of the config)
Thanks