Home > SIX 2013 Documentation > Knowledge Base > How do I manually move my SIX Server?

How do I manually move my SIX Server?

Question/Background

 

How do I manually move my SIX Server? Ok, this question really comes in more like a bunch of frantic statements/questions, e.g. "My server crashed over the weekend!! I don't have a backup of my SIX Server!!! I can access the files on the old hard drive though, can I recover my data??? I swear I'll make weekly, even daily backups if you can get my data restored!!!".

 

In this scenario, often times you are not always moving servers, you may just be re-installing on the same machine once you have corrected the issue you encountered.

 

If you do have a backup of your SIX Server, skip this post and simply restore your backup.

Answer

 

Data Needed

 

From the "old" SIX Server you will need to get the following files and folder. Place them on some medium that the "new" SIX Server can access.

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SystemIntegrator.mdf

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SystemIntegrator_log.LDF

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SystemIntegratorProjects.mdf

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SystemIntegratorProjects_log.LDF

C:\DToolsSIXData

 

Note: the "MSSQL.1" folder may vary on your machine depending on how many instances of SQL have been installed on your machine.

Installing on "new" Machine

 

  1. Install the SIX Server. You can always get the latest installation package for SIX from the links below:
    Client - http://downloads.d-tools.com/six/upd.../SIXClient.exe
    Server - http://downloads.d-tools.com/six/upd.../SIXServer.exe
  2. Once the SIX Server is installed, open the SIX Server Manager (Start->All Programs->D-Tools SIX->SIX Server Manager) and click the big button at the top of the interface to stop your SIX service:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/stop_service.jpg

 

  1. Paste the files you recovered above into the exact same locations on this machine. When prompted to overwrite the exiting files, allow this.
  2. Open the SIX Server Manager (Start->All Programs->D-Tools SIX->SIX Server Manager) and click the big button at the top of the interface to start your SIX service:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/start_service.jpg

Detaching/Re-Attaching Databases

 

The database must be detached and re-attached.

 

We recommend using Microsoft SQL Server Management Studio Express 2005 to accomplish this. This is free and can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

Note: If your server is running Windows 8 or Windows Server 2012, you will need to install Microsoft SQL Server Management Studio Express 2012.

 

  1. Open Microsoft SQL Server Management Studio Express
  2. Login to the correct SQL instance on this machine, the default is "DTOOLSSIX", by clicking [Connect]:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/log_in_to_ssms.jpg

 

  1. Expand "Databases" in the Object Explorer section.
  2. Select "SystemIntegrator", right-click and select Tasks->Detach...

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/detach.jpg

 

  1. Click the "Drop Connections" option on the Detach Database form and click [OK]. The database will be removed from the list.

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/detach_databse_form.jpg

 

  1. Repeat steps 4-5 for the "SystemIntegratorProjects" database.
  2. Right-click on "Databases" in the Object Explorer section and select Attach...

 

​​attach.jpg

 

  1. On the Attach Databases form, click the [Add] button:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/attach_databases_form_1.jpg

 

  1. On the Locate Database Files form, click "SystemIntegrator.mdf" and then click [OK]:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/locate_database_files.jpg

 

  1. Click [OK] on the Attach Databases form:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/attach_databases_form_2.jpg

 

  1. Repeat steps 7-10 for the "SystemIntegratorProjects.mdf" file.

Fixing the Login for the Databases

 

  1. Right-click the "SystemIntegrator" database and select New Query:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/new_query.jpg

 

  1. Type the following line of code, verbatim, then click the [Execute] button:

 

sp_change_users_login 'AUTO_FIX','DToolsData'

 

query.jpg

 

You will see following confirmation that an orphaned was fixed:

 

fixed orphan.jpg

 

  1. Repeat steps 1-2 for the "SystemIntegratorProjects" database.
  2. Close SQL Server Management Studio. When you are prompted to save your queries, choose [No].

​Login From a SIX Client

 

  1. On a machine running the SIX Client, launch SIX 2013. You may get a message that the SIX Server is currently unavailable:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/six_server_currently_unavailable.jpg

 

  1. Click [Close] then type in the new name or IP address of your SIX Server in the login form.

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/server_name.jpg

 

Instead of the login form above, may first get the following message if this is a new machine/hard drive:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/invalid_license.jpg

 

If you get the message above click [OK], then click [Cancel] on the login form. Then click Start->Help->Register and enter your CD Key:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/register.jpg

 

After registered, click Start->Connect->Connect to Server and then enter your new server name as shown above:

 

File:SIX_Guide/003_Administration/FAQ_-_Administration/How_do_I_manually_move_my_SIX_Server?/connect_to_server.jpg

Last modified
14:18, 30 Oct 2015

Tags

Classifications

This page has no classifications.