Learn more

About managing your server

Creating a SQL Server instance

Moving companies to a different SQL Server instance

Removing a SQL Server instance

Use this tool to to remove a SQL Server instance (for example, if you have moved your Sage 100 Contractor companies to a different drive on your computer, and now need to delete the original instance, or if you create an instance in error).

Before you start

  • On your computer, locate the Microsoft SQL Server setup file with which you created the instance you now want to remove. 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.

    If you created the instance with an earlier version of Microsoft SQL Server, and overwrote the original setup file with a later version, you may need to download the earlier version again. (We recommend that if you do so, you download it to a distinct folder to avoid overwriting the existing setup file.)

  • Remove any companies that are connected to the SQL Server instance. See Deleting a Company for instructions.

To remove a SQL Server instance:

  1. Start Database Administration, and connect to your current SQL Server instance.
  2. Click Server Management > Remove SQL Server instance.

  3. Fill out the fields on the Create SQL Server instance tab:

    1. Select the SQL Server instance to remove. Select the instance from the list.

    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.

  4. Click [Remove instance].