arrow_back

Deploy Microsoft SQL Server to Compute Engine

Join Sign in

Deploy Microsoft SQL Server to Compute Engine

45 minutes 1 Credit

GSP031

Google Cloud self-paced labs logo

Note: This lab requires right-click functionality in a windows-server virtual machine. It is significantly easier to complete with a mouse.

Overview

Compute Engine lets you create and run virtual machines on Google infrastructure. There is a catalog of public application images available, including a variety of Microsoft SQL Server and Windows versions.

In this lab you will learn how to create a virtual machine with Microsoft SQL Server installed. You'll create a Windows user and password, and learn how to connect to the Windows Server via remote desktop.

What you'll learn

  • How to stand up a virtual machine running Microsoft SQL Server on Compute Engine

  • How to create a Windows user and password

  • How to remote desktop into a Windows Server virtual machine

Prerequisites

  • Basic familiarity with Microsoft SQL Server and RDP Connections

  • Either a Windows machine or a non-Windows machine with Chrome. Other RDP Clients should suffice but instructions for their use are not provided in this lab.

Setup and requirements

Before you click the Start Lab button

Read these instructions. Labs are timed and you cannot pause them. The timer, which starts when you click Start Lab, shows how long Google Cloud resources will be made available to you.

This hands-on lab lets you do the lab activities yourself in a real cloud environment, not in a simulation or demo environment. It does so by giving you new, temporary credentials that you use to sign in and access Google Cloud for the duration of the lab.

To complete this lab, you need:

  • Access to a standard internet browser (Chrome browser recommended).
Note: Use an Incognito or private browser window to run this lab. This prevents any conflicts between your personal account and the Student account, which may cause extra charges incurred to your personal account.
  • Time to complete the lab---remember, once you start, you cannot pause a lab.
Note: If you already have your own personal Google Cloud account or project, do not use it for this lab to avoid extra charges to your account.

How to start your lab and sign in to the Google Cloud Console

  1. Click the Start Lab button. If you need to pay for the lab, a pop-up opens for you to select your payment method. On the left is the Lab Details panel with the following:

    • The Open Google Console button
    • Time remaining
    • The temporary credentials that you must use for this lab
    • Other information, if needed, to step through this lab
  2. Click Open Google Console. The lab spins up resources, and then opens another tab that shows the Sign in page.

    Tip: Arrange the tabs in separate windows, side-by-side.

    Note: If you see the Choose an account dialog, click Use Another Account.
  3. If necessary, copy the Username from the Lab Details panel and paste it into the Sign in dialog. Click Next.

  4. Copy the Password from the Lab Details panel and paste it into the Welcome dialog. Click Next.

    Important: You must use the credentials from the left panel. Do not use your Google Cloud Skills Boost credentials. Note: Using your own Google Cloud account for this lab may incur extra charges.
  5. Click through the subsequent pages:

    • Accept the terms and conditions.
    • Do not add recovery options or two-factor authentication (because this is a temporary account).
    • Do not sign up for free trials.

After a few moments, the Cloud Console opens in this tab.

Note: You can view the menu with a list of Google Cloud Products and Services by clicking the Navigation menu at the top-left. Navigation menu icon

Task 1. Deploy Microsoft SQL Server

Create a new Compute Engine virtual machine instance running Microsoft SQL Server from the Cloud Console.

  1. In Cloud Console, click the Menu icon for Navigation menu in the top left of the screen:

The Navigation menu icon

  1. Then click Compute Engine:

The Compute Engine option highlighted in the Compute section of the expanded navigation menu

  1. Then, click CREATE INSTANCE.

The Create Instance button highlighted on the VM instances page

  1. Next, name the new instance sqlserver-lab.

  2. Choose a zone as us-central1-f.

  3. Click Change to change the boot disk.

  4. Remain in the Public images tab:

The Public images tab highlighted in the Boot Disk section

  1. For the operating system, select SQL Server on Windows Server. For the version, select SQL Server 2016 Web on Windows Server 2016 Datacenter.

  2. At the bottom of the window, click Select.

  3. Click Create.

Note: You will see a warning about being billed for this instance. You will not be billed for these resources because you are using credentials provided to run this lab. It's good to keep in mind that any instances you create in your personal or work accounts will be billed to you.

This will take you to a new page where you can see the new instance being created. A checked green circle appears when the instance is ready.

A green checkmark alongside the sqlserver-lab instance

You will be able to remote desktop (RDP) into the machine from this page after you create a Windows user and password.

Click Check my progress to verify the objective. Deploy Microsoft SQL Server

Task 2. Create a Windows user and password

To RDP into the Windows instance, you must create a Windows user and password.

  1. To create them, click the name of your instance, sqlserver-lab, to see the instance details.

  2. Then, select Set Windows password.

This will open a new window where you create a user.

  1. Copy and save the default username for later use and select Set.

After a few seconds, you should have a New Windows password dialog with the newly created password.

  1. Click the rectangles alongside the password to copy the password.

Copy and paste with the RDP client

Once you are securely logged in to your instance, you may find yourself copying and pasting commands from the lab manual.

  • To paste, hold the CTRL-V keys (if you are a Mac user, using CMND-V will not work.)
  • If you are in a Powershell window, be sure that you have clicked in to the window or else the paste shortcut won't work.
  • If you are pasting into putty, right click.

Click Check my progress to verify the objective. Create a Windows user and password

Task 3. Remote desktop (RDP) into the Windows Server

It's time to RDP into the Windows Server. There are two different ways to do this, depending on whether or not you are on Windows. Let's go through them both.

Not running Windows

  1. If you are not on Windows but are using Chrome, open Spark View extension page in normal window.

  2. Click on Add to Chrome. Then, click Launch app button.

  3. It opens up a login page, add your VM instance's External IP in Computer field.

  4. Then enter your Windows user name and password and click Connect.

Running Windows

  1. If you are on a Windows machine, download the RDP file by selecting it from the RDP dropdown menu.

  2. Double click the RDP file and log in using the Windows user and password.

Task 4. Run Microsoft SQL Server Management Studio

  1. Inside your remote desktop window, click the Start menu, and type Microsoft SQL.

  2. Then right click Microsoft SQL Server Management Studio and Run as administrator.

Note: If you are on a Mac trackpad, try placing two fingers on the trackpad and clicking with your thumb in order to emulate a right-click. Note: If you do not run SQL Server Management Studio as administrator the connection will not work.

Microsoft SQL Server Management Studio launches, showing you a Connect to Server window.

  1. Click Connect.

  2. Then, use the Object Explorer window to examine your new database.

Congratulations!

Compute Engine is the foundation to Google Cloud's Infrastructure-as-a-Service. As you've seen, application images make it easy to run Microsoft SQL Server.

Finish your quest

This self-paced lab is part of the Windows on Google Cloud quest. A quest is a series of related labs that form a learning path. Completing this quest earns you a badge to recognize your achievement. You can make your badge or badges public and link to them in your online resume or social media account. Enroll in this quest and get immediate completion credit. Refer to the Google Cloud Skills Boost catalog for all available quests.

Take your next lab

Continue your quest with Deploy an ASP.NET Core App to App Engine, or check out these suggestions:

Next Steps

Google Cloud training and certification

...helps you make the most of Google Cloud technologies. Our classes include technical skills and best practices to help you get up to speed quickly and continue your learning journey. We offer fundamental to advanced level training, with on-demand, live, and virtual options to suit your busy schedule. Certifications help you validate and prove your skill and expertise in Google Cloud technologies.

Manual Last Updated September 15, 2022

Lab Last Tested June 10, 2022

Copyright 2022 Google LLC All rights reserved. Google and the Google logo are trademarks of Google LLC. All other company and product names may be trademarks of the respective companies with which they are associated.