Skip to main content
Version: OpCon (Cloud - Current)

Editing Remote Instances

A remote instance defines the connection details that OpCon uses to communicate with a separate OpCon database. Use this procedure to update the connection properties of an existing remote instance in Enterprise Manager.

For conceptual information about each field, refer to Remote Instances in the Concepts online help.

Edit a remote instance

To edit a remote instance, complete the following steps:

  1. Select Remote Instances under the Administration topic. The Remote Instances screen opens.

  2. Select the remote instance you want to change in the Selection list. The instance details populate the form.

  3. Update any of the following fields as needed:

    Remote OpCon section

    FieldDescription
    NameUnique name for the remote instance (maximum 255 characters).
    DocumentationOptional free-text notes for the remote instance (maximum 8,000 characters).
    ServerHostname or IP address of the remote SQL Server. Required.
    DatabaseName of the remote OpCon database. Required.
    Windows AuthenticationWhen selected, OpCon connects using the Windows service account. The User and Password fields are disabled.
    UserSQL Server login name. Required when Windows Authentication is not selected.
    PasswordPassword for the SQL Server login. Required when Windows Authentication is not selected. Stored encrypted (AES).

    Options section

    FieldDescription
    Mirroring OnSelect when the remote SQL Server uses database mirroring.
    Transparent Network IP ResolutionControls SQL Server multi-subnet failover behavior. Options: Auto (default), Enabled, Disabled. Auto is recommended in most environments.
  4. Select Save icon Save on the Remote Instances toolbar.

  5. Select Close (to the right of the Remote Instances tab) to close the Remote Instances screen.

Result: The updated connection details are saved to the OpCon database and take effect the next time the remote instance connection is referenced.