{"id":5564,"date":"2020-11-02T17:52:21","date_gmt":"2020-11-02T08:52:21","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=5564"},"modified":"2022-12-27T12:03:01","modified_gmt":"2022-12-27T03:03:01","slug":"5564","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=5564","title":{"rendered":"ServiceDesk Plus\u306e\u7ba1\u7406\u8005\u300cadministrator\u300d\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30ea\u30bb\u30c3\u30c8\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"https:\/\/pitstop.manageengine.com\/portal\/en\/kb\/articles\/how-to-reset-administrator-password-in-servicedesk-plus\">How to reset administrator password in ServiceDesk Plus<\/a>\u3092\u53c2\u8003\u306b\u3001<br \/>\nServiceDesk Plus\u306e\u7ba1\u7406\u8005\u300cadministrator\u300d\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30ea\u30bb\u30c3\u30c8\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><iframe loading=\"lazy\" title=\"How to reset administrator password in ServiceDesk Plus\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/e1bxMbcuEww?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<ol>\n<li>ServiceDesk Plus\u30b5\u30fc\u30d0\u30fc\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\uff1c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\uff1e\\ManageEngine\\ServiceDesk\\bin\u306b\u79fb\u52d5\u3059\u308b<\/li>\n<li>changeDBServer.bat\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u8a2d\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u60c5\u5831\u3092\u8868\u793a\u3059\u308b\n<div class=\"point\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304cMSSQL\u306e\u5834\u5408\u3001SQL Management Studio\u306b\u79fb\u52d5\u3057\u30016\u756a\u76ee\u306e\u30b9\u30c6\u30c3\u30d7\u306b\u9032\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/li>\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304cPostgreSQL\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u30ca\u30ec\u30c3\u30b8\u3092\u53c2\u8003\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b<br \/>\n<a href=\"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=389\">PostgreSQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u624b\u9806<br \/>\n<\/a><\/li>\n<li>Windows\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u7ba1\u7406\u8005\u3068\u3057\u3066\u5b9f\u884c\u3059\u308b<\/li>\n<li>\n<p class=\"zw-paragraph heading0\">\uff1c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\uff1eManageEngine\\ServiceDesk\\pgsql\\bin\u306b\u79fb\u52d5\u3057\u3001<br \/>\n\u30fbServiceDesk Plus\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c10.5\u4ee5\u964d\/AssetExplorer\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c6.5\u4ee5\u964d\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u3092\u5b9f\u884c\u3059\u308b<\/p>\n<blockquote><p>psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1<\/p><\/blockquote>\n<p>\u30fbServiceDesk Plus\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c10.5\u4ee5\u524d\/AssetExplorer\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304c6.5\u4ee5\u524d\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u3092\u5b9f\u884c\u3059\u308b<\/p>\n<blockquote><p>psql.exe -U postgres -p 65432 -d servicedesk -h 127.0.0.1<\/p><\/blockquote>\n<div class=\"point\">\u30d7\u30ed\u30f3\u30d7\u30c8\u304c\u8868\u793a\u3055\u308c\u305f\u3089\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u300csdp@123\u300d\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/li>\n<li>\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u30b3\u30d4\u30fc\u3057\u3066\u8cbc\u308a\u4ed8\u3051\u3001Enter\u30ad\u30fc\u3092\u62bc\u4e0b\u3059\u308b<br \/>\n\u30fbSDOrgAdmin \u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30af\u30a8\u30ea (ServiceDesk Plus 11.0 \/ AssetExplorer 6.6 \u4ee5\u964d)<\/p>\n<blockquote><p>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';<\/p><\/blockquote>\n<p>\u30fbSDAdmin \u3092\u53d6\u5f97\u3059\u308b\u30af\u30a8\u30ea (ServiceDesk Plus 11.0 \/ AssetExplorer 6.6 \u4ee5\u524d)<\/p>\n<blockquote><p>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';<\/p><\/blockquote>\n<\/li>\n<li>\u30af\u30a8\u30ea\u51fa\u529b\u5f8c\u306e\u7d50\u679c\u304b\u3089\u3001\u30e6\u30fc\u30b6\u30fc\u3092\u9078\u629e\u3057\u3001\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3067login_id\u3092\u4f7f\u7528\u3057\u3066\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30ea\u30bb\u30c3\u30c8\u3059\u308b<br \/>\n\u30fb\u30d0\u30fc\u30b8\u30e7\u30f3\u304c ServiceDesk Plus 10.5 \/ AssetExplorer 6.5 \u4ee5\u964d\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b<\/p>\n<blockquote><p>PostgreSQL\uff1aupdate 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);<\/p><\/blockquote>\n<blockquote><p>MSSQL\uff1aOPEN 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 ;<\/p><\/blockquote>\n<div class=\"zw-paragraph heading0 attention\">MSSQL\u306b\u3064\u3044\u3066\u306e\u6ce8\u610f\u4e8b\u9805\uff1a\u4e0a\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u9593\u306bServiceDesk Plus\u3092\u8d77\u52d5\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<p>\u30fb\u30d0\u30fc\u30b8\u30e7\u30f3\u304cServiceDesk Plus 10.5 \/ AssetExplorer 6.5 \u4ee5\u524d\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b<\/p>\n<blockquote><p>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);<\/p><\/blockquote>\n<p>\u30fb\u30d0\u30fc\u30b8\u30e7\u30f3\u304cServiceDesk Plus 9.3 \/ AssetExplorer 6.2 \u4ee5\u524d\u306e\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b<\/p>\n<blockquote><p>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);<\/p><\/blockquote>\n<div class=\"attention\">\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30ea\u30bb\u30c3\u30c8\u3059\u308b\u3068\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u300cadmin\u300d\u3068\u306a\u308a\u3001\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u300c\u30ed\u30b0\u30a4\u30f3\u5148\u300d\u306e\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u30ea\u30b9\u30c8\u3067\u300c\u30ed\u30fc\u30ab\u30eb\u8a8d\u8a3c\u300d\u304c\u9078\u629e\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/li>\n<li>ServiceDesk Plus\u3067\u30ed\u30fc\u30ab\u30eb\u8a8d\u8a3c\u304c\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u6709\u52b9\u306b\u3059\u308b<br \/>\n<blockquote><p>update globalconfig set paramvalue='true' where parameter='Enable_LocalAuthentication_Login';<\/p><\/blockquote>\n<\/li>\n<li>\u4e0a\u8a18\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u305f\u3089\u3001ServiceDesk Plus\u3092\u518d\u8d77\u52d5\u3059\u308b<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to reset administrator password in ServiceDesk Plus\u3092\u53c2\u8003\u306b\u3001 ServiceDesk Pl\u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/?p=5564\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[3612272,3],"tags":[342,605,215,3612150],"class_list":["post-5564","post","type-post","status-publish","format-standard","hentry","category-faq-sdp","category-trouble-sdp","tag-administrator","tag-605","tag-215","tag-3612150"],"modified_by":"daiki","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/5564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5564"}],"version-history":[{"count":20,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/5564\/revisions"}],"predecessor-version":[{"id":5566,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=\/wp\/v2\/posts\/5564\/revisions\/5566"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/ServiceDesk_Plus\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}