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.
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.
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.
sp_change_users_login 'AUTO_FIX','DToolsData'
You will see following confirmation that an orphaned 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 registered, click Start->Connect->Connect to Server and then enter your new server name as shown above: