For MYSQL Database:
Connect to the MYSQL database. To know how to connect to the MYSQL database, refer the link below,
Step 1: Find the Domain ID.
mysql> 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.[ Screenshot ]
Step 2: Query the table SdActivedirectory info which stores the Domain Controller information.
mysql> select * from sdactivedirectoryinfo where domain_id=601; [ Screenshot ]
Step 3: Update the Domain Controller information.
mysql> update sdactivedirectoryinfo set server_name=’helpdesk-test1′ where domain_id=601; [ Screenshot ]
This should update the Domain Controller in the database after which you should be able to login to ServiceDeskPlus.
For MSSQL Database:
Connect to the query analyzer of the SQL server and follow the same 3 steps.