1. Connect to Database Administration for Sage 100 Contractor
2. Click Tune Up/Back Up/Restore, Back-Up Companies
3. Select all the boxes in the Company column on the right.
4. Click Create Backup
5. After the backups are completed, on a separate backup drive or the desktop of the new server, create a folder named "Sage100CON Files from Old Server"
6. On the current Sage 100 Contractor database server, open Windows File Explorer
7. Copy the following folders from the Sage100CON folder on the current Sage 100 Contractor database server to the “Sage100CON Files from Old Server” folder you created in the preceding step.  Ensure to copy the following folders separately. Do not simply copy the entire Sage100Con folder:
   1. Sage 100Con\Backups
   2. Sage100Con\Common\Banking Cloud (if present and contains a BankingCloudSettings.xml file).
   3. Sage100Con\Common\Custom Reports (if present)
   4. Sage100Con\Common\Customization (if present)
   5. Sage100Con\Common\File Attachment Settings (if present)
   6. Sage100Con\Partner Data (if using third-party applications with Sage 100 Contractor)
   7. Sage100Con\Common\Report Forms
   8. Sage 100Con\Common\User Data
8. Connect to License Administration for Sage 100 Contractor
9. Click the License information tab.  Take note of the Sage client ID and the Registration Name, which is case-sensitive. You will need this information later.
10. Click Deauthorize license server

Verify Microsoft .NET Framework versions 3.5 and 4.8 are installed and install Sage 100 Contractor to the new server

 

1. Open the Windows Control Panel
2. Select Programs and Features
3. Select Turn Windows features on or off (on the upper left side)
4. Verify the .Net Framework 3.5 and 4.8 boxes are marked.
5. Download the Sage 100 Contractor installation file
6. Install Sage 100 Contractor on the new server.
7. Run the Sage100Contractor2####_Setup.exe file.  You may be prompted to install .Net 4.6 which will require a restart of your server.
8. Click Next
9. Select the following items to install.
   1. Sage 100 Contractor (Server and Workstations) are required.
   2. Database Administration (Server only) is required.
   3. License Administration (Server only) is required.
   4. Sage Advisor Update (Server only)
10. Click Next
11. Select I agree
12. Click Next
13. Select, either the U.S. Edition or the Canadian Edition
14. Click Install
15. Write down, your IP address or Server name.
16. Click Next
17. Click Finish

Install Microsoft™ SQL Server Express

1. Open Database Administration for Sage 100 Contractor
2. Select the logical drive (physical disk drive) to store your data. The drive cannot be a mapped drive.
3. Click OK 
4. Click the link Install SQL Server Express. Microsoft SQL Express 2019 RTM™ will be automatically downloaded.
5. Click OK and allow MS SQL Server to install.  The task may require some time to complete.
6. Important: After the installation is complete, a screen containing an sa password will be displayed. It is highly recommended to take a screenshot or record the sa password before closing the window. This username sa and its associated password can be used for emergency access to the Database Administration for Sage 100 Contractor applet, in the event other user names and passwords fail to allow you access.
7. Click OK
8. Click Connect

Activate your product license

1. Connect to License Administration for Sage 100 Contractor
2. Click Edit registration information, on the right.
3. Enter your Sage client ID
4. Enter Your Registration name (Case sensitive)
5. Click Update license information
6. Close License Administration for Sage 100 Contractor

Copy Sage100Con\Common folders to the new server

1. Open Windows File Explorer
2. From the folder named Sage100CON Files from Old Server, that you created earlier when you were at the old server, copy the folders (noted below, in bold text) to the \\Sage100Con\Common directory on the new server:
   1. Banking Cloud
   2. Custom Reports
   3. Report Forms
   4. Customization
   5. File Attachment Settings
   6. Partner Data
   7. User Data

Restore your Sage 100 Contractor company databases:

1. Connect to Database Administration for Sage 100 Contractor
2. Click Tune Up / Back Up / Restore…
3. Click Restore Company from Backup
4. Click Browse. Browse to Sage100CON Files from Old Server/Backups/On Demand
5. Select the [companyname].zip file to restore
6. Click the Open button,
7. Click Restore Company
8. Confirm you receive the message Restoration of [company name] is complete.
9. Repeat these steps for each company database.

Correct broken user logins:

Refer to How to fix a Broken Login in Sage 100 Contractor SQL

Change your server Attachment links:

Refer to How to change the server for attachment links when the target files have been moved to another server or the server name changes

Recreate Scheduled Reports:

Refer to How to create and run a scheduled report