Quickstart for Cloud SQL for SQL Server

MySQL   |  PostgreSQL   |  SQL Server

This page shows you how to create and connect to a SQL Server instance and perform basic SQL operations using the Google Cloud Console and a client. The resources created in this Quickstart typically cost less than a dollar, assuming you complete the steps, including the clean up, in a timely manner.

Set up your project

Before performing the steps in this quickstart, complete the following tasks:

1. 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.

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

   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

3. Make sure that billing is enabled for your Cloud project. Learn how to confirm that billing is enabled for your project.

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

   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

5. Make sure that billing is enabled for your Cloud project. Learn how to confirm that billing is enabled for your project.

6. Make sure you have the Cloud SQL Admin role on your user account.
   • Go to the IAM page.
     Go to the IAM page
   • Click Add.
   • In New Principals, add your user account name.
   • In Select a role, filter for Cloud SQL Admin and select it from the list.
   • Click Save.
7. Enable the Cloud SQL Admin API.

   Enable the API

Note: If you are running a local instance of SQL Server, stop it before beginning to work with a Cloud SQL instance. Otherwise you might encounter errors such as address already in use.

Create a Cloud SQL instance

In this procedure, you use the Google Cloud Console. To use the gcloud, cURL, or PowerShell, see Creating instances.

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

   Go to Cloud SQL Instances

2. Click Create Instance.
3. Click SQL Server.
4. If you're prompted to enable the Compute API, click the Enable API button.
5. Enter myinstance for Instance ID.
6. Enter a password for the sqlserver user.
7. Use the default values for the other fields.

8. Click Create.

   You are returned to the instances list; you can click into the new instance right away to see the details, but it won't be available 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 using SQL Server Management Studio

Note: SQL Server Management Studio (SSMS) is a Windows-based, integrated environment. Review the SSMS documentation as needed, including for Connecting to a SQL Server instance. Alternatively, you can use other database administration tools.

1. Install the Cloud SDK. The Cloud SDK provides the gcloud tool to interact with Cloud SQL and other Google Cloud services. The gcloud tool uses the Admin API to access Cloud SQL, so you must Enable the Admin API before using the gcloud tool to access Cloud SQL.
2. In a bash shell command prompt or in Windows PowerShell, run the following command to initialize the gcloud tool:

   gcloud init
   

3. Run the following command to authenticate the gcloud tool:

   gcloud auth login
   

4. 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.
5. Run the Cloud SQL Auth proxy using a bash shell command prompt (or using Windows PowerShell). Specifically, run the following command, replacing Instance-connection-name with the corresponding value from the Google Cloud Console's Overview tab (for your instance):

   ./cloud_sql_proxy -instances=[Instance-connection-name]=tcp:1433
   

For more information about installing and using the Cloud SQL Auth proxy, see About the Cloud SQL Auth proxy.

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

Connect using the SSMS Object Explorer

1. In SSMS, select Connect Object Explorer from the File menu.

   {: class="screenshot"}

2. Enter the following values in the Connection dialog:

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

Create a database and upload data

1. In the SSMS Object Explorer window, right-click the Databases node under your instance and select New Database.

   

2. Enter testdb for the Database name and click the OK button.

   

3. Under the newly created testdb database, right-click the Tables node and select New > Table.

   

4. Enter the following values in the Create table dialog:

   1. In the Properties window, for Identity > Name, enter guestbook.
   2. For the first Column Name, enter entryID, set its Data Type to int, and clear the Allow Nulls checkbox.
      1. In the Column Properties window, expand the Identity Specification item and set (Is Identity) to Yes.
   3. For the second Column Name, enter guestname and set its Data Type to varchar(255).
   4. For the third Column Name, enter content and set its Data Type to varchar(255).

   

5. Click the File menu and select Save guestbook.

   

6. Right-click the testdb table under Databases and select New Query.

   

7. Enter the following two INSERT statements into the SQL query text window and click the Execute button.

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

   As an example:

8. Expand the Tables item under the Databases > testdb item in the Object Explorer window. Right-click the dbo.guestbook table and choose Select Top 1000 Rows.

   

The two records you inserted are displayed as Results, along with the SQL SELECT statement used to query the records.

Cleanup

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

   Go to Cloud SQL Instances

2. Select your instance's name to open the Overview page.
3. In the icon bar at the top of the page, click Delete.

4. In the Delete instance window, type your instance's name, then click Delete to delete the instance.

   You cannot reuse an instance name for about 7 days after the instance is deleted.

What's next

Based on your needs, you can learn more about creating Cloud SQL instances.

You also can learn about creating SQL Server users and databases for your Cloud SQL instance.

Also see the Cloud SQL pricing information.

In this quickstart you connected to the instance using Cloud Shell. In most use cases, how you connect depends on your networking configuration, such as:

• If your Cloud SQL instance has a public or private IP address.
• If you're connecting from inside Google Cloud (from the same project or from a different project).
• If you're connecting from outside of Google Cloud.

Learn more about:

• All of the connectivity options in Cloud SQL.
• Configuring your Cloud SQL instance with a public IP address.
• Configuring your Cloud SQL instance with a private IP address.

Additionally, you can learn about connecting to a Cloud SQL instance from other Google Cloud applications:

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