Occasionally, DCT cannot automatically discover a SQL Server instance. This can occur if there is a problem in the Windows registry or if the instance is not running when discovery occurs. In these cases, you can manually add the SQL Server installation from the environment page.

Manually add a SQL Server installation

Use this procedure to manually add a SQL Server installation to a Windows environment in DCT.

  1. Log in to the DCT instance.
  2. On the Home page, go to the environment and click View to view its attributes.
  3. Select the Data tab.
  4. Click + Installation.
  5. Enter the following details:
    • Allow Provisioning: Select this option to allow linking and provisioning.
    • Use as Staging: Select this option if the environment will be used as a staging environment.
    • Fulltext Installed: Select this option to allow users to perform full-text searches.
    • Add as a Failover Cluster Source: Select this option when adding a SQL Server failover cluster instance as a source. When this option is selected, enter the server name. This option applies only when adding a SQL Server failover cluster instance as a source. It is not available for clusters used as a target.
    • Name: Not currently used.
    • Port: The port used for the IPC connection to the instance.
    • Installation path: The SQL Server installation path. Not currently used.
    • Owner: The account that runs the SQL Server service on the source environment.
    • Version: The SQL Server version required to add a source instance. If the wrong version is entered, Delphix might fail to discover the databases, and manual discovery might fail.
  6. Click Save.

If the values are valid, DCT creates the instance and discovers its databases.

Delete a manually added SQL Server installation

You can delete a SQL Server installation that was manually added to a Windows environment.

  1. Log in to the DCT instance.
  2. On the Home page, go to the environment and click View to view its attributes.
  3. Select the Data tab.
  4. Locate the manually added SQL Server installation.
  5. Click the delete icon at the far right of the installation row.
  6. Click Delete.

DCT deletes the manually added SQL Server installation and its discovered databases.

Last updated
Oct 9, 2026