Skip to main content

How do I manually move my SI Server?

A
Written by Ashok P
Updated this week

How do I manually move my SI Server?

If you have a backup of your SI Server, skip this post and restore your backup.

This process is demonstrated for installations that use our Express Configuration (default) option when configuring your SI server, e.g., all file paths are the default.

Data Needed

From the "old" SI Server, you will need to get some files and folders and place them on a medium that the "new" SI Server can access.

It is important to note that as of SI 17, we install SQL Server Express 2019 during the SI Server installation. If you installed SI before SI v17, you will be on an older version of SQL Server Express, likely either 2017 or 2012.

Files and Folders for SQL Server Express 2019

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegrator.mdf

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegrator_log.ldf

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorLogs.mdf

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorLogs_log.ldf

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorProjects.mdf

  • C:\Program Files\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorProjects_log.ldf

  • C:\DToolsSIXData

Files and Folders for SQL Server Express 2017 or earlier

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegrator.mdf

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegrator_log.ldf

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorLogs.mdf

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorLogs_log.ldf

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorProjects.mdf

  • C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.DTOOLSSIX\MSSQL\DATA\SystemIntegratorProjects_log.ldf

  • C:\DToolsSIXData

The "MSSQL11.DTOOLSSIX" folder may vary on your machine depending on how many instances of SQL have been installed on your machine, what version of SQL you are using, and whether or not you did a Custom Configuration vs. the Express Configuration (default).

Installing on a New Machine

1/ Install the SI Server.

2/ Open the SI Server Manager and click the big button at the top of the interface to stop your SI service.

stop service.jpg

3/ Paste the files you recovered above into the exact same locations on this machine*. If prompted to overwrite the existing, allow this.

If you are moving these files from a previous version of SQL Server Express (2017 or 2012) to a machine running SQL Server Express 2019, the path will change from C:\Program Files (x86) to C:\Program Files.

4/ Open the SI Server Manager and click the big button at the top of the interface to start your SI service.

start service.jpg

Detaching and Reattaching Databases

The database must be detached and reattached. You will need Microsoft SQL Server 2012 Management Studio Express (or later) to accomplish this.

This is free and can be downloaded from https://go.microsoft.com/fwlink/?linkid=849819.

Make sure that you download the 32-bit version.

32 bit management studio.png

1/ Open Microsoft SQL Server 2012 Management Studio Express.

2/Log in to the correct SQL instance on this machine. The default is DTOOLSSIX when clicking Connect.

connect to server login.png

3/ Expand Databases in the Object Explorer section.

4/ Select SystemIntegrator, right-click, and select Tasks > Detach.

detach databases.png

5/ Click the Drop Connections option on the Detach Database form and click OK.

The database will be removed from the list.

drop check box.png

6/ Repeat steps 4-5 for the SystemIntegratorProjects database.

7/ Repeat steps 4-5 for the SystemIntegratorLogs database.

8/ Right-click Databases in the Object Explorer section and select Attach.

attach database.png

9/ On the Attach Databases form, click the Add button.

add database button.png

10/ On the Locate Database Files form, click SystemIntegrator.mdf and then OK.

selected database.png

11/ Click OK on the Attach Databases form.

added database.png

12/ Repeat steps 7-10 for the SystemIntegratorProjects.mdf file.

13/ Repeat steps 7-10 for the SystemIntegratorLogs.mdf file.

Fixing the Login for the Databases

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

new query.png

2/ Type the following line of code, verbatim, then click the Execute button.

sp_change_users_login 'AUTO_FIX','DToolsData'

query execute.png

You will see the following confirmation that an orphaned user was fixed.

orphans.png

3/ Repeat steps 1-2 for the SystemIntegratorProjects database.

4/ Repeat steps 1-2 for the SystemIntegratorLogs database.

5/ Close SQL Server Management Studio.

6/ When you are prompted to save your queries, choose No.

Log in From an SI Client

1/ On a machine running the SI Client, launch the SI Client.

You may get a message that the SI Server is currently unavailable.

server unavailable.jpg

2/ Click Close, then type in the new name or IP address of your SI Server in the login form.

new server name.jpg

Instead of the login form above, you may get the following message if this is a new machine or hard drive.

invalid license.png

3/ If you get the message above, click OK and Cancel on the login form.

4/ Then click Start > Help > Register and enter your license Key.

register.jpg

5/ After registering, click Start > Connect > Connect to Server and enter your new server name as shown above.

connect.jpg
Did this answer your question?