0

In this configuration I have a Compute Engine instance in GCP running Windows Server 2019. I have two network adapters; one that is connected to the public network, and one that is connected to an internal virtual network called DMZ. I then have a Cloud SQL instance running SQL Server, also configured with Private IP and running on the virtual network called DMZ.

However, I am not able to actually connect to the IP address of the Cloud SQL instance using SQL Server Management Studio from the Compute Engine node.

Here are some additional details:

  • VM is connected to two networks: default with a 172... IP, and dmz with a 10.142... IP; OS is Windows Server 2019
  • Cloud SQL has a Private IP only, connected to dmz with a 10.52... IP; running SQL Server 2017 Web
  • VPC Network dmz has Private Service Connection created with 10.52... IP range
  • VPC Network default is stock, no modifications
  • All resources are in the same region (US-East-1)
  • tracert from VM to Cloud SQL fails/times out

How does one go about enabling access? I have followed all the steps and can't get it to work so any help would be greatly appreciated.

3
  • Please provide more details about your use case and steps you followed. – Serhii Rohoza Feb 25 at 10:08
  • @SerhiiRohoza Added more details - any thoughts? – A X Feb 26 at 5:18
  • Have you added firewall rules to allow this communication? – Sergiusz Feb 26 at 9:12
1

It turns out that the problem was caused by having two NICs. Once I made a new VM with only one NIC it was fine.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.