Creating a new SQL Server instance

If you need to create a new SQL Server instance (for example, if you want to move your Sage 100 Contractor archive companies to a different drive on your computer), use this tool to create a new SQL Server instance. When you use this tool to create a new instance, the program configures the instance using the settings that Sage 100 Contractor requires.

Important! The version of SQL Server on the new instance should be the same or a later version than that used for your Sage 100 Contractor data.

To create a new SQL Server instance:

  1. Start Database Administration and connect to your current SQL Server instance.
  2. Click Server Management > Create SQL Server instance.
  3. Fill out the fields on the Create SQL Server Instance tab:

    1. Enter a name for the new SQL Server instance. You can use up to 16 characters for the new instance name.

      Note: The name cannot start with a space or a $ sign.

    2. Enter the setup file for the SQL Server installation. Browse to the location where you stored the SQL Server installation files, and then select the executable file.

      If you installed SQL Server Express when you installed Sage 100 Contractor, this will likely be the Sage 100 Contractor download folder—for example, C:\Sage100Con\Downloads\SQLEXPRADV_v64_ENU.EXE.

    3. Select the checkboxes for the access and communication options you want to enable for the new instance.

      If you are allowing access to the new instance only for approved applications:

      1. Click [Edit Approvals].
      2. In the Enable Access from Other Applications window, select the checkboxes for the applications that are allowed to connect to the instance.
      3. Click [OK].
  4. Click [Create instance].

After creating an instance