Desktop Central extends support for using MS SQL database for storing the configuration and data. This document will explain the steps to configure Desktop Central and MS SQL Server to use MS SQL as the back end database. The following steps can be followed to set up a fresh MS SQL database or migrate data from an existing database to new MS SQL database. For both of these cases, you should first upgrade to build #80256 or above versions before following any of these steps.
Note : Desktop Central Supports MS SQL 2005 or later versions.
The following steps will explain you, to backup the data from the old server, change the database server and restore the data in the MS SQL database.
Note: Ensure that the you configure Windows firewall to allow access to SQL server. Refer this document for more information.
Fig: Windows Authentication
Fig: SQL Server Authentication
Ensure that the collation for the Desktop Central folder in MSSQL database is set as SQL_Latin1_General_CP1_CI_AS if it is not set, follow the steps mentioned below to change the collation.
5. Start Desktop Central.
You can start using Desktop Central which has been migrated from the previous location.