After creating an ODBC connection to your SIOS Protection Suite cluster via the protected IP address, the connection fails after switching the SQL resource to the backup server.

Suggested Action:

  1. Take each instance out of service and bring it back into service on the PRIMARY. Examine the application event log to determine which IP:PORT that particular SQL Server instance is listening on.
  1. Bring each hierarchy In Service on the SECONDARY server and note the IP:PORT each SQL instance is listening on.
  1. To insure your clients can connect via ODBC to either server, make sure the PORT each instance is listening on is the same on both the PRIMARY and SECONDARY servers.
  1. To do this, use the Microsoft SQL Server Network Utility. Select the SQL instance (it must be running on that machine), highlight the TCP/IP protocol and look at the properties to determine the current default port it is listening on.
  1. Change this value so the default PORT is the same on both systems for this instance.
  1. Create your ODBC connections for each instance using the protected IPs:PORTs you just set up in Step 5.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment