Return
-
Title
How to move the ITSS config DB to a new server -
Description
I would like to move the ITSS config database to a new server because we are decommissioning the old server -
Cause
N/A -
Resolution
If the ITSS config db is stored on a SQL server and not in SQL Express:
- Turn off the ITSS and web publishing services on the ITSS host
- Open up regedit and navigate to the following key
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Aelita\ADC\CfgConnection
- Take a backup of the registry key
- Make note of the values of the following keys
"Data Source" - This is the hostname of the SQL server that is currently hosting the ITSS configuration database
"Initial Catalog" - This is the name of the ITSS configuration database
- Open up SQL Management Studio and connect to the SQL server that is hosting the configuration DB
- Make a full backup of the ITSS configuration DB
- Take the database offline and detach it from the SQL server
- Copy the MDF and LDF files for the ITSS config db onto the new SQL host that you are migrating to
- Attach the db file and bring the database online, make sure you take it out of read only mode and verify the permissions are intact
- Back on the ITSS host, modify the "Data Source" and "Initial Catalog" registry keys to reflect the new location and name of the ITSS config DB
- Bring the services back online, or reboot the ITSS host
- Once the host is back online, test ITSS to make sure that it is working properly. If it is not, then you will need to go back over each step to find out where you made mistakes or typos.