This topic describes how to add a SQL Server standalone target environment to the Delphix Engine.
As explained in Setting Up SQL Server Environments: An Overview, you can use SQL Server targets for three purposes in a Delphix Engine deployment:
- They can host a target environment for the provisioning of Virtual Databases (VDBs)
- They can host a staging database for a linked dSource and run the validated sync process
- They can serve as a proxy host for database discovery on source hosts
Regardless of the specific purpose, all Windows targets must have the Delphix Connector installed to enable communication between the host and the Delphix Engine. The instructions in this topic cover initiating the Add Target process in the Delphix Engine interface, running the Delphix Connector installer on the target machine, and then verifying that the target has been added in the Delphix Engine interface.
- Make sure that your target environment meets the requirements described in Requirements for SQL Server Target Hosts and Databases.
- On the Windows machine that you want to use as a target, you will need to download the Delphix Connector software through the Delphix Engine interface, install it and then register that machine with the Delphix Engine.
Flash Player Required for Connector Download
A Flash player must be available on the target host to download the Delphix Connector when using the Delphix GUI. If the target host does not have a Flash player installed, you can download the connector directly from the Delphix Engine by navigating to this URL:
http://<name of your Delphix Engine>/connector/DelphixConnectorInstaller.msi
- From the machine that you want to use as a target, start a browser session and connect to the Delphix Engine GUI using the delphix_admin login.
- Click Manage.
- Select Environments.
- Next to Environments, click the green Plus icon.
- In the Add Environment dialog, select Windows in the operating system menu.
- Select Target.
- Select Standalone.
- Click the download link for the Delphix Connector Installer.
The Delphix Connector will download to your local machine.
On the Windows machine that you want to want to use as a target, run the Delphix Connector installer. Click Next to advance through each of the installation wizard screens.
The installer will only run on 64-bit Windows systems. 32-bit systems are not supported.
- For Connector Configuration, make sure there is no firewall in your environment blocking traffic to the port on the target environment that the Delphix Connector service will listen to.
- For Select Installation Folder, either accept the default folder, or click Browse to select another.
- Click Next on the installer final 'Confirm Installation' dialog to complete the installation process and then Close to exit the Delphix Connector Install Program.
- Return to the Delphix Engine interface.
- Enter the Host Address, Username, and Password for the target environment.
- Click Validate Credentials.
- Click OK to complete the target environment addition request.
- As the new environment is added, you will see two jobs running in the Delphix Admin Job History, one to Create and Discover an environment, and another to Create an environment. When the jobs are complete, you will see the new environment added to the list in the Environments panel.
- On the target machine, in the Windows Start Menu, click Services.
- Select Extended Services.
- Ensure that the Delphix Connector service has a Status of Started.
- Ensure that the Startup Type is Automatic.