Moving the MDB database for Service Desk from one SQL Server instance to another.

Document ID : KB000054087
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

Describes the process to move the MDB tables from one Microsoft SQL Server instance to another and point Service Desk at the new location.

Solution

The DBA will need to move the MDB from the originating SQL Server instance to the new SQL Server instance using Database utilities like Backup and Restore.
After the Restore is complete, it is necessary to run the following command to fix the database login:
Exec sp_change_users_login 'AUTO_FIX', 'ServiceDesk'

Once the data has been moved and the permissions correctly set, launch pdm_configure on the Service Desk Server. On the Database Config screen change the Node to point at the new instance. Make sure "Load default data" is unchecked and continue. Once pdm_configure has completed Service Desk will be restarted and will utilize the newly created MDB instance.

If there are any problems connecting to this new instance of the MDB pdm_configure will fail and can be cancelled out of without any changes being made. Service Desk can be restarted and will continue to use the original MDB tables while the cause of the connection failure is reviewed and corrected.