Setting BIG-IP LTM Virtual Server for two SQL Servers nodes
I've created BIG-IP Virtual Edition instance in Amazon EC2 using this tutorial.
I've followed this tutorial to configure BIG-IP System as an MS SQL Database Proxy. There were couple things that I didn't get in "Creating a database proxy virtual server" section:
- For the Destination setting, in the Address field, type the IP address you want to use for the virtual server. The IP address you type must be available and not in the loopback network.
- In the Service Port field, type 1443.
Which IP address should I use in destination field? Public IP, which I use to connect to BIG-IP WEB UI?
Why it says set service port to 1443, not 1433, which is default to SQL Server?
For now I set public IP and 1443 port and tried to verify connection using UDL file
I have two DB nodes and when trying to verify connection directly to their IP addresses - connection succeeds. But when I try BIG-IP public IP - connection fails with the following error message:
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Both nodes are enabled and available in LTM (Local Traffic Manager).
Any ideas what I'm doing wrong?