Cannot connect to SQL Server (VPN Protected)

Google Cloud Compute Infrastructure
1

The idea is to connect to a SQL Server database that is protected by a VPN through Data Fusion and any other Google services I want to use.

The error I get is the following: “Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”

Reading in several articles they told me to configure a Private IP from the Datafusion instance, but as for the connection to that base it is necessary in other tools, how could that IP be added at the project level in GCP?

2

These steps could help you to resolve the issue:

  1. Allocate a new IP range (the old IP range could have been overlapped with the Cloud SQL IP range, so creating the VPC peering was running into conflict issues causing failures).
  2. Re-create the private CDF instance using the allocated IP range
  3. Create an ingress firewall rule, but with a different port, and add both the allocated IP range from step 1 and the internal IP for the compute engine VM created to the Source IP Ranges field.
  4. Test the connection from the compute engine VM to the CloudSQL SQL Server instance.