We upgraded our Domain Controller and forgot to change it in ServiceDesk Plus – MSP. Now, the application will not let me login and I forgot the local admin password. How do I update the domain controller information without logging into the application?
Step 1:Connect to the database of ServiceDesk Plus – MSP,
Step 2: Find the Domain ID.
servicedesk> select * from domaininfo;
The list of domains available in ServiceDesk Plus appears. Let’s assume that you want to change the domain controller for the domain ZOHO.
Make a note of the Domain ID which is 601.
Step 3: Query the table SdActivedirectory info which stores the Domain Controller information.
servicedesk> select * from sdactivedirectoryinfo where domain_id=601;
Step 4: Update the Domain Controller information.
servicedesk> update sdactivedirectoryinfo set server_name=’helpdesk-test1′ where domain_id=601;
This should update the Domain Controller information in the database after which you should be able to login to ServiceDesk Plus – MSP.