Connect to Cloud SQL for SQL Server from SSMS

Create a Cloud SQL instance

In this quickstart, you use the Google Cloud console. To use the gcloud CLI , cURL, or PowerShell, see Create 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 Choose SQL Server.
4. In the Instance IDfield, enter myinstance .
5. In the Passwordfield, enter a password for the sqlserver user.

6. Click Create instance.

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

Connect to your instance by using SQL Server Management Studio

1. Optional: If you're running a local instance of SQL Server, stop it before connecting to your Cloud SQL instance. Otherwise, you might encounter errors such as address already in use .
2. Install the gcloud CLI . The gcloud 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:

     
   gcloud  
   init  
   

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

     
   gcloud  
   auth  
   login  
   

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, replacing Instance-connection-name with the corresponding value from the Google Cloud console's Overview tab (for your instance):

     
   ./cloud-sql-proxy  
    INSTANCE_CONNECTION_NAME 
     
   

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 by using SSMS and the localhost IP address.

Connect using the SSMS Object Explorer

1. In SSMS, select Connect Object Explorerfrom the Filemenu.

   

2. Enter the following values in the Connectiondialog:

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

Create a database and upload data

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

   

2. Enter testdbfor the Database nameand click the OKbutton.

   

3. Under the newly created testdbdatabase, right-click the Tablesnode and select New > Table.

   

4. Enter the following values in the Create tabledialog:

   1. In the Propertieswindow, for Identity > Name, enter guestbook.
   2. For the first Column Name, enter entryID, set its Data Type to int, and clear the Allow Nullscheckbox.
      1. In the Column Propertieswindow, expand the Identity Specificationitem and set (Is Identity)to Yes.
   3. For the second Column Name, enter guestnameand set its Data Type to varchar(255).
   4. For the third Column Name, enter contentand set its Data Type to varchar(255).

   

5. Click the Filemenu and select Save guestbook.

   

6. Right-click the testdbtable under Databasesand select New Query.

   

7. Enter the following two INSERT statements into the SQL querytext window and click the Executebutton.

    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 Tablesitem under the Databases > testdbitem in the Object Explorerwindow. Right-click the dbo.guestbooktable 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.