I have created a private SQL Server instance and trying to access it on Virtual Machine instance using SQL Server proxy using the link (
As stated in the documentation you referenced, you
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