This page describes how to connect a SQL Server client, whether running locally on your client machine or on a Compute Engine VM, to your Cloud SQL instance.
Before you begin
Before you can start using a client, you must have:
Created a Cloud SQL instance, including configuring the default user.
Optionally, created a Compute Engine VM instance and then connected to the instance using SSH.
Determined how you will connect to your instance.
For the connection options and how to choose from among them, see the Connecting overview page.
- Installed the SQL Server command-line tools.
Using a client on a local machine or a Compute Engine VM
Using a sqlcmd client to connect to your Cloud SQL instance involves three high-level tasks:
- Install the client.
- Configure access to your Cloud SQL instance.
- Connect to your Cloud SQL instance.
Install the client
To install the client:
For Debian/Ubuntu, install the applicable SQL Server command-line tools using these instructions.
For CentOS/RHEL, install the applicable SQL Server command-line tools using these instructions.
For openSUSE, install the applicable SQL Server command-line tools using these instructions.
Configure access to your Cloud SQL instance
To configure access to your instance:
- From the client machine or Compute Engine VM instance, use What's my IP to see the IP address of the client machine.
- Copy that IP address.
In the Google Cloud Console, go to the Cloud SQL Instances page.
- Click the instance name to open its Overview page.
- Select Connections from the SQL navigation menu.
- In the Authorized networks section, click Add network and enter the IP address of the machine where the client is installed.
- Click Done. Then click Save at the bottom of the page to save your changes.
- Connect to your instance.
Connect to your Cloud SQL instance
To connect to your instance:
- Confirm that you have installed the client and configured access to your instance.
- Use the
sqlcmdcommand to connect, by following steps similar to those in the examples on the SQL Server quickstart and Use the utility pages.
To connect to your instance using SSL:
- Learn about the two levels of access control for Cloud SQL instances.
- Create users and databases.
- Learn about configuring an instance with a private IP address.
- Learn more about SQL Server.
- Learn about options for support.
Try it for yourself
If you're new to Google Cloud, create an account to evaluate how Cloud SQL performs in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.Try Cloud SQL free