How do I manually move my SI 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 SI 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 SI Server, skip this post and simply restore your backup.
This process is demonstrated for installations that use our Express Configuration (default) option when you configured your SI server, e.g. all file paths are the default.
From the "old" SI Server you will need to get the following files and folder. Place them on some 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 prior to SI v17 then you will be on an older version of SQL Server Express, likely either 2017 or 2012.
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
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
Note: 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).
Note: 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.
The database must be detached and re-attached. 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
Note: Makes sure that you are download the 32-bit version.
sp_change_users_login 'AUTO_FIX','DToolsData'
You will see following confirmation that an orphaned user was fixed:
Instead of the login form above, may first get the following message if this is a new machine/hard drive:
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:
After you are registered, click Start->Connect->Connect to Server and then enter your new server name as shown above: