Home > Software design >  Sqlcmd error while connecting with SQL Server instance on a VM using SQL Server proxy
Sqlcmd error while connecting with SQL Server instance on a VM using SQL Server proxy

Time:03-19

I have created a private SQL Server instance and trying to access it on Virtual Machine instance using SQL Server proxy using the link (enter image description here

As stated in the documentation you referenced, you enter image description here

enter image description here

Additionally if your Compute Engine instance is in the same region as your Cloud SQL instance, you may want to consider another way to connect these instances. In the Connect from Compute Engine documentation, you can find the instructions on how to connect from a CE instance to a private IP of a Cloud SQL instance as long as both of these instances are on the same region.

CodePudding user response:

The above issue might occur when the private service access connection breaks for the SQL server instance on GCP platform. That is when some one mistakenly removes the peering. The above error resolves when we create/update the existing peering connection. The solution is posted in the link Unable to recreate Private Service Access on GCP

  • Related