Accessing SQL Server on cloud from remote

R. K. Nair

unread,

Dec 28, 2017, 11:18:19 AM12/28/17

to Google App Engine

What is the connection information that I have to use from my office (Using local sql server Management studio) to connect to a SQL database created on Google Cloud?

I tried the external IP of the VM instance as the server name, but it does not accept. However, I can ping to that external IP without any problems.

Please see the picture included.

Thanks.

001.png

Yannick (Cloud Platform Support)

unread,

Dec 28, 2017, 12:38:28 PM12/28/17

to google-a...@googlegroups.com

As per the guide on Connecting mysql Client Using IP Addresses you can whitelist IPs to allow connections from outside of the Google Cloud network. Once access is configured, you should be able to connect to the instance just like you would with any other SQL instance.

I hope this helps.

R. K. Nair

unread,

Dec 28, 2017, 4:25:53 PM12/28/17

to Google App Engine

No,it is not s

R. K. Nair

unread,

Dec 28, 2017, 4:27:10 PM12/28/17

to Google App Engine

No, it is not sql

I have the database installed on a standalone windows server. It has an external ip that I can ping to. However, cannot connect using SQL Server Management Studio.

On Thursday, December 28, 2017 at 11:38:28 AM UTC-6, Yannick (Cloud Platform Support) wrote:

Navi Aujla (Google Cloud Support)

unread,

Dec 29, 2017, 4:14:26 PM12/29/17

to Google App Engine

Hello

You can check if the port associated with the SQL services is open on the GCP firewall for this Windows server instance, in order to make a connection. Also, verify Windows server firewall is not blocking the the port associated.

For best practices for SQL server instances, you can refer to this documentation.

FYI: Google offers GCE instances images with SQL as well.

Reply all

Reply to author

Forward