Iscsi an Error Occurred Please Try Again

Configuring SQL Server Hosts to Connect to the Delphix Engine Over Some other Network (KBA1792)

Last updated
Save as PDF

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
six.0	6.0.0.0, six.0.i.0, half dozen.0.1.1, six.0.two.0, 6.0.2.1, half-dozen.0.3.0, half-dozen.0.3.i, 6.0.four.0, half-dozen.0.four.1, 6.0.4.2, 6.0.five.0, half-dozen.0.6.0, 6.0.half-dozen.i, 6.0.seven.0
5.3	5.3.0.0, v.three.0.1, 5.three.0.2, 5.3.0.iii, v.3.1.0, v.3.i.1, v.3.one.ii, 5.3.ii.0, 5.3.3.0, 5.three.iii.i, 5.3.4.0, 5.3.5.0 5.3.half dozen.0, 5.3.7.0, 5.3.7.1, five.iii.8.0, 5.iii.viii.1, 5.3.ix.0
v.2	five.ii.2.0, v.2.2.1, 5.2.iii.0, 5.ii.four.0, v.2.5.0, 5.ii.5.1, five.2.vi.0, 5.2.vi.1
v.1	five.1.0.0, 5.ane.1.0, 5.1.two.0, five.1.iii.0, 5.i.iv.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.i.vii.0, 5.1.8.0, 5.1.8.1, five.1.9.0, 5.1.10.0
v.0	5.0.1.0, 5.0.one.1, v.0.2.0, 5.0.two.i, 5.0.2.2, 5.0.2.three, 5.0.3.0, 5.0.three.1, 5.0.4.0, 5.0.4.1 ,five.0.v.0, 5.0.5.1, 5.0.5.ii, 5.0.5.three, five.0.5.four

Summary

Occasionally, it may exist necessary to change the network that the Delphix Engine uses for advice with SQL Server target hosts. For example, the Delphix Engine may be configured with a 2nd network interface to permit communication over a storage network or dedicated switch.

This document describes the steps required to allow the utilize of the new network. This involves clearing the iSCSI configuration on the Target host, and reconfiguring the host using Delphix Engine'south Management interface.

Please notation that it is not currently possible to "split" advice, so that iSCSI action takes place over 1 network while JDBC activity occurs over another. All traffic between the Delphix Engine and the Target host will catamenia through the new network.

Prerequisites

Earlier proceeding with the steps in this document:

The new network adapters must be configured on the Target host, including having an IP address assigned
The new network adapter must be added and configured on the Delphix Engine, using the Server Setup interface

Configuring Connectivity Over Another Network

one. Examination connectivity using new devices

One time the network is configured, validate that the advisable connectivity is in place.

The Delphix Engine'due south Network Performance Tool (bachelor in the CLI, or the GUI since v.two) will permit you to examination that the target's new IP address is reachable
The Target should be able to ping the Delphix Engine's new IP accost
The Target must be permitted to connect to the Delphix Engine's new IP address using:
- TCP port 3260 (iSCSI)
- TCP port 50001 (optional, for network throughput testing)
The Delphix Engine must be permitted (both through the Network and past the Windows Firewall) to reach the Target's new IP accost using:
- TCP Port 9100 (Delphix Connector communication)
- TCP Port 8415 (Delphix Session Protocol, or DSP)
- ICMP (for ping/traceroute)
- TCP Port 50001 (optional, for network throughput testing)

Storage network interfaces are probable to utilise the "Public" network profile in Windows, and existing Windows Firewall rules may need to be modified to allow this communication.

Note that port 50001 is simply in utilize while network throughput tests are running.

two. Disable all VDBs

To review all VDBs attached to a target, apply the Databases tab of the Manage → Environments screen:

Each Staging Database and VDB should be Disabled from the Manage → Datasets screen:

This stride can also exist done using the CLI, Delphix Toolkit, or delphixpy.

3. Open the iSCSI Initiator control console applet

Connect to the Target host (for example via Remote Desktop), and launch the iSCSI Initiator control panel applet from the Start Menu or via iscsicpl.exe.

If at that place are multiple Delphix Engines or other iSCSI Devices connected to the host, accept care when making any changes.

The Volumes and Devices, RADIUS and Configuration tabs can be left unmodified. The Volumes and Devices tab does not contain whatsoever information specific to IP address, and volition probable be empty later the VDBs has been disabled.

iv. Remove the Favorite Target

If in that location is merely ane Delphix Engine continued to this target, it can be removed from the Favorite Targets tab by selecting information technology and clicking the Remove button.

If there are multiple targets listed, you can confirm the correct iSCSI target by selecting each and clicking Details. The target to exist removed should match the Delphix Engine's electric current IP address.

If in that location are multiple devices, make a note of the Target proper name of the target you are removing, equally it volition be used in the side by side step.

5. Disconnect the Target

Switch to the Targets tab and Disconnect from the Delphix Engine's iSCSI Target. The Proper noun should match the Target Name that was removed from the Favorite Targets tab.

If prompted to disconnect from whatsoever active sessions, select Aye:

half-dozen. Remove the Target Portal

Switch to the Discovery tab, and Remove the Target portal that matches the Delphix Engine'southward existing IP address:

This should complete without prompting, and will as well remove the portal from the list in the Targets tab.

seven. Change the Host Address in the Delphix Engine

Using the Delphix Engine's Management Interface, open up the Manage → Environments screen and select the Target host.

To modify the Host Address for the environment, use the Edit (Pencil) icon next to the Attributes panel:

Update the Host Accost to reflect the new IP accost, and then use the Save (Tick) icon to confirm the modify:

This will automatically trigger an action to Refresh the Environs. The refresh process includes steps to configure the iSCSI Target, and verify that it is reachable.

eight. Enable VDBs

From the Manage → Datasets screen, Enable each dSource and VDB that was Disabled in Footstep 2.

ix. Test VDB Beliefs

In one case the VDBs have been successfully enabled, ensure that they answer correctly to queries, and are providing the latency and throughput that you expect from the new network.

Troubleshooting Errors

The post-obit warnings or errors may occur while attempting to reconfigure the Target Host or Delphix Engine.

Error: "Failed to add or update the iSCSI persistent login target"

When attempting to alter the Host Accost of an Environment, you may receive the error:

Failed to add or update the iSCSI persistent login target on host "<HOSTNAME>".

This suggests that some configuration of the iSCSI Target is withal present on the Target host. Ensure that all VDBs and dSources which utilize the Target are disabled, and attempt Step iii again.

Error: "An IO error occurred while attempting to write a remote file on host <HOSTNAME>."

When attempting to modify the Host Address of an Environment, yous may receive the mistake:

An IO error occurred while attempting to write a remote file on host <HOSTNAME>.

This suggests that network configuration may be inconsistent betwixt the Delphix Engine and the Target host. Ensure that the Colossal Frames configuration is consequent between the Delphix Engine, the Target host, and all intermediate network devices.

schockwhirosed1942.blogspot.com

Source: https://support.delphix.com/Continuous_Data_Engine_%28formerly_Virtualization_Engine%29/MSSQL_Server/Configuring_SQL_Server_Hosts_to_Connect_to_the_Delphix_Engine_Over_Another_Network_%28KBA1792%29