This page shows you how to create and connect to a SQL Serverinstance and perform basic SQL operations by using the Google Cloud console anda client. The resources created in this quickstart typically cost less than adollar, assuming you complete the steps, including the cleanup, in a timelymanner.

Before you begin

Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.

In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

Roles required to select or create a project

• Select a project: Selecting a project doesn't require a specific IAM role—you can select any project that you've been granted a role on.
• Create a project: To create a project, you need the Project Creator role (roles/resourcemanager.projectCreator), which contains theresourcemanager.projects.create permission.Learn how to grant roles.

Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

Go to project selector

Verify that billing is enabled for your Google Cloud project.

In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

Roles required to select or create a project

• Select a project: Selecting a project doesn't require a specific IAM role—you can select any project that you've been granted a role on.
• Create a project: To create a project, you need the Project Creator role (roles/resourcemanager.projectCreator), which contains theresourcemanager.projects.create permission.Learn how to grant roles.

Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

Go to project selector

Verify that billing is enabled for your Google Cloud project.

1. Enable the necessary Google Cloud APIs.

   Console

   In the Google Cloud console, go to theAPIs page.

   Go to APIs

   Enable the Cloud SQL Admin API.

   gcloud

   Click the following button to open Cloud Shell, which provides command-line access to your Google Cloud resources directly from the browser. Cloud Shell can be used to run thegcloud commands presented throughout this quickstart.

   Open Cloud Shell

   Run thegcloud services enable command as follows using Cloud Shell to enable the APIs required for this quickstart.:

   gcloudservicesenablesqladmin.googleapis.com

   This command enables the following APIs:

   • Cloud SQL Admin API

2. Make sure that you have the following role or roles on the project: Cloud SQL Admin (roles/cloudsql.admin)

   Check for the roles

   1. In the Google Cloud console, go to theIAM page.

      Go to IAM
   2. Select the project.

   3. In thePrincipal column, find all rows that identify you or a group that you're included in. To learn which groups you're included in, contact your administrator.

   4. For all rows that specify or include you, check theRole column to see whether the list of roles includes the required roles.

   Grant the roles

   1. In the Google Cloud console, go to theIAM page.

      Go to IAM
   2. Select the project.
   3. Clickperson_addGrant access.

   4. In theNew principals field, enter your user identifier. This is typically the email address for a Google Account.

   5. In theSelect a role list, select a role.
   6. To grant additional roles, clickaddAdd another role and add each additional role.
   7. ClickSave.

Create a Cloud SQL instance

In this quickstart, you use the Google Cloud console. To use thegcloud CLI, cURL, or PowerShell, seeCreate instances.

1. In the Google Cloud console, go to theCloud SQL Instances page.

   Go to Cloud SQL Instances

2. ClickCreate instance.
3. ClickChoose SQL Server.
4. In theInstance ID field, entermyinstance.
5. In thePassword field, enter a password for thesqlserver user.

6. ClickCreate instance.

   You're returned to the instances list. You can click the new instance rightaway to see the details, but it won't be available for other operations until it initializes and starts.

   Note: In this example, the instance is created using default settings, including a public IP address.

Connect to your instance by using SQL Server Management Studio

1. Optional: If you're running a local instance of SQL Server, stop it beforeconnecting to your Cloud SQL instance. Otherwise, you might encountererrors such asaddress already in use.
2. Install thegcloud CLI. Thegcloud CLI provides the gcloud CLI to interact with Cloud SQL and other Google Cloud services. The gcloud CLI uses the Admin API to access Cloud SQL, so you must Enable the Admin API before using the gcloud CLI to access Cloud SQL.
3. In a bash shell command prompt or in Windows PowerShell, run the following command to initialize the gcloud CLI:

   gcloudinit

4. Run the following command to authenticate the gcloud CLI:

   gcloudauthlogin

5. Download and install the Cloud SQL Auth Proxy (see Installing the Cloud SQL Auth Proxy). Note the location of the Cloud SQL Auth Proxy because you will run the Cloud SQL Auth Proxy in next step.
6. Run the Cloud SQL Auth Proxy by using a bash shell command prompt (or by using Windows PowerShell). Specifically, run the following command, replacingInstance-connection-name with the corresponding value from the Google Cloud console's Overview tab (for your instance):

   ./cloud-sql-proxyINSTANCE_CONNECTION_NAME

For more information about installing and using the Cloud SQL Auth Proxy, seeAbout the Cloud SQL Auth Proxy.

As described in the next section, now you can connect to your SQL Serverinstance by using SSMS and the localhost IP address.

Connect using the SSMS Object Explorer

1. In SSMS, selectConnect Object Explorer from theFile menu.

   

2. Enter the following values in theConnection dialog:

   1. For Server Type, enterDatabase Engine.
   2. For Server Name, enter 127.0.0.1 as the IP address of your SQL Server instance.
   3. For Authentication, enterSQL Server Authentication.
   4. For Login, entersqlserver.
   5. For Password, enter the password used when the instance was created.
3. Click theConnect button.

Create a database and upload data

1. In the SSMS Object Explorer window, right-click theDatabases node underyour instance and selectNew Database.

   

2. Entertestdb for theDatabase name and click theOK button.

   

3. Under the newly createdtestdb database, right-click theTables node andselectNew > Table.

   

4. Enter the following values in theCreate table dialog:

   1. In theProperties window, forIdentity > Name, enterguestbook.
   2. For the firstColumn Name, enterentryID, set its Data Type toint, and clear theAllow Nulls checkbox.
      1. In theColumn Properties window, expand theIdentitySpecification item and set(Is Identity) toYes.
   3. For the secondColumn Name, enterguestname and set itsData Type to varchar(255).
   4. For the thirdColumn Name, entercontent and set its Data Typeto varchar(255).

   

5. Click theFile menu and selectSave guestbook.

   

6. Right-click thetestdb table underDatabases and selectNew Query.

   

7. Enter the following two INSERT statements into theSQL query text windowand click theExecute button.

   INSERTINTOguestbook(guestName,content)values('first guest','I got here!');INSERTINTOguestbook(guestName,content)values('second guest','Me too!');

   As an example:

8. Expand theTables item under theDatabases > testdb item in theObjectExplorer window. Right-click thedbo.guestbook table and chooseSelectTop 1000 Rows.

   

The two records you inserted are displayed asResults, along with the SQLSELECT statement used to query the records.

Clean up

To avoid incurring charges to your Google Cloud account for the resources used on this page, follow these steps.

1. In the Google Cloud console, go to theCloud SQL Instances page.

   Go to Cloud SQL Instances

2. Select themyinstance instance to open theInstance details page.
3. In the icon bar at the top of the page, clickDelete.
4. In theDelete instance window, type your instance's name and then clickDelete.

Optional cleanup steps

If you're not using the APIs that were enabled as part of this quickstart, youcan disable them.

• APIs that were enabled within this quickstart:
  • Cloud SQL Admin API

1. In the Google Cloud console, go to theAPIs page.

   Go to APIs

2. Select the Cloud SQL Admin API and then click theDisable API button.

What's next

• Learn aboutcreating Cloud SQL instances.

• Learn about creatingSQL Server users anddatabases for your Cloud SQL instance.

• See theCloud SQL pricing information.

• In this quickstart you connected to the instance by using Cloud Shell.Learn about all of theconnectivity options in Cloud SQL.How you connectdepends on your networking configuration, such as if your Cloud SQL instancehas a public or private IP address. See how toconfigure your Cloud SQL instance with apublic IP and aprivate IP address.

• Learn about connecting to a Cloud SQL instance from other Google Cloudapplications:

  • From an application running on the App Engine standard environment
  • From an application running on Compute Engine
  • From an application running on GKE
  • From Cloud Run