How to migrate the databases using the setup tool (4243350)

There are multiple ways to move the Kace Desktop Authority databases, in this article using the Kace Desktop Authority Setup tool will be utilized.

Before beginning this procedure, verify the user account used to restore the databases has rights within SQL to create a database on the new server, otherwise the restore will fail.

Kace Desktop Authority uses two databases: DAConfiguration and DAReporting

Open the setup tool via Start | All Programs | Quest | Desktop Authority Manager | Desktop Authority Setup Tool

Note:  For version 9.1 and earlier the path is Start | All Programs | ScriptLogic Corporation | Desktop Authority Manager | Desktop Authority Setup Tool

Go to the “DB Configuration” tab, verify that the correct server and instance is shown, then click “Connect”:

Next, select the “DB Tasks” tab then select DAConfiguration from the “Database name” drop down menu:

In the “Backup database” section at the bottom left, click the “Browse” button and provide a location to save the backup to:

By default a name will be populated in the “File name” field, this name can be changed if necessary, then click “OK”:

Next, click the “Backup database” button:

A green check mark will appear once the backup has completed.

Repeat the steps above for the DAReporting database. 

Once both databases have been backed up, copy the backups to a location accessible for restoring.

Go back to the “DB Configuration” tab in the setup tool and browse to the new SQL server and instance name:

Once the new SQL server and instance has been selected click “Connect”

Next, go back to the “DB Tasks” tab, select the DAConfiguration database and click the “Restore database” button:

Browse to the location where the backup was saved, select it and click “OK”:

The restore operation will be complete when the green check mark appears:

Repeat the steps above for the DAReporting database.

Now that both databases have been restored, go to the “DB Configuration” tab and click “Edit properties”:

On the “Configure Properties” window that is displayed click on the “Browse” button and browse to the new SQL server and instance name:

Click “Add Selected” then click the “Next” button back on the “Configure Properties” screen

Then configure the service credentials for the Desktop Authority Manager Service and the Application pool identity and click “Update”:

Finally click “Yes” to restart the Desktop Authority Manager Service: