Toad World Blog

Using Toad for SQL Server with Google Cloud Platform - I

Aug 8, 2018 2:08:36 PM by Deepak Vohra

Toad for SQL Server is an integrated development environment (IDE) for accessing, managing, and using SQL Server database. Google Cloud Platform provides virtual machines (VMs) pre-configured to run SQL Server. The advantages of using Google Compute engine include a scalable, high-performance, distributed compute environment with predefined virtual machine types that support different CPU, memory and OS configurations. In three articles we shall discuss using Toad for SQL Server for connecting with SQL Server running on Windows Server based VM on Google Compute engine and use the database to create a database, create a table, add table data, and query the table. The articles have the following sections:

Setting the Environment

Creating a Google Cloud Platform Project

Creating a Windows Server Based Virtual Machine for SQL Server Database

Setting the Windows Password

Connecting to Windows Server with RDS

Installing Toad for SQL Server on Windows

Connecting to SQL Server Database with Toad for SQL Server

Choosing a Database

Opening and Arranging Toad for SQL Server Views

Creating a Database Table with New Table Wizard

Exploring Database Objects with Explorer

Adding Table Data with SQL Editor

Querying a Table

Dropping a Table

Disconnecting and Reconnecting

Using Multiple Connections

Dropping a Connection

Stopping and Deleting  a VM Instance

Closing the RDS Connection

Setting the Environment

Download and install the following Google Chrome extension for a remote desktop.

Create a Google Cloud Platform account and create a billing account at https://console.cloud.google.com/billing as shown in Figure 1.

d1

Figure 1. Billing Account

Creating a Google Cloud Platform Project

Open the Google Cloud Platform Console at https://console.cloud.google.com/start .  Click on Create an empty project as shown in Figure 2.

d2

Figure 2. Create an empty project

In New Project dialog specify a Project name (SQLServer) and click on Create as shown in Figure 3.

d3

Figure 3. New Project dialog

In the Google Cloud Platform Getting Started page click on Select a project as shown in Figure 4.

 d4

Figure 4. Select a project

The SQLServer project should be getting created. When the project gets created the project is shown with a check mark (shown in Figure 6).

d5

Figure 5. Project created

Navigate to the projects page with URL https://console.cloud.google.com/cloud-resource-manager and the SQLServer project is listed, as shown in Figure 6. Click on the project link.

d6

Figure 6. Project listed in Resources

The project detail gets displayed, as shown in Figure 7.

d7

Figure 7. Project Info

Creating a Windows Server Based Virtual Machine for SQL Server Database

In this section we shall create a Windows Server based virtual machine (VM) for SQL Server. Open URL https://cloud.google.com in a browser and click on the Compute section as shown in Figure 8.

d8

Figure 8. Selecting Compute

In Compute Products page click on View Compute Engine as shown in Figure 9.

d9

Figure 9. View Compute Engine

In Compute Engine click on View Console as shown in Figure 10.

d10

Figure 10. View Console

It may take a minute or more for the Compute Engine to get ready. On the VM instances page click on Create in the VM instances dialog as shown in Figure 11.

d11

Figure 11. VM instances>Create

The Create an instance wizard gets started, as shown in Figure 12. Specify an instance Name (sql-server-instance).

d12

Figure 12. Create an instance Wizard

Click on Change for Boot disk as shown in Figure 13.

d13

Figure 13. Boot disk>Change

Select the Application images tab and select from one of the SQL Server application images as shown in Figure 14.

d14

Figure 14. Selecting a SQL Server application image

In the Create an instance wizard the Boot disk gets set to the selected application image, as shown in Figure 15.

 d15

Figure 15. Boot Disk Image selected

Keep the default settings for the other configuration. Click on Create. A VM instance gets created, as shown in Figure 16. The VM lists two IP addresses, an Internal IP and an External IP. We only need to make use of the External IP to access the VM externally from a local or cloud-based machine.

d16

Figure 16. New VM Instance

Setting the Windows Password

To be able to access the VM instance from a local machine using Chrome RDP we need to set a Windows password. A Windows password may be set from two different  selections. On the VM instances listing click on the drop-down for Connect>RDP as shown in Figure 17 and select Set Windows password.

d17

Figure 17. RDP>Set Windows password

The other option is to click on the VM instance link and in the VM instance details page click on Set Windows password in Remote access>RDP section. In Set new Windows password specify a Username or select the default one and click on SET as shown in Figure 18.

d18

Figure 18. Set new Windows password

A New Windows password window displays a new password, as shown in Figure 19. Click on Copy to copy the password to the clipboard. Click on Close.

d19

Figure 19. New Windows password

Connecting to Windows Server with Chrome RDS

In this section we shall connect to the Windows Server based VM from a local machine using Chrome RDS. Launch the Chrome RDP as shown in Figure 20.

d20

Figure 20. Chrome RDP

Next, copy the External IP for the VM instance as shown in Figure 21.

d21

Figure 21. Obtaining the External IP

Copy and paste the External IP in the Chrome RDP console and click on Connect as shown in Figure 22.

d22

Figure 22. Connecting to VM with Chrome RDP

In the Enter your credentials window, shown in Figure 23, specify Username and Password as configured in Setting the Windows Password section. Click on OK. The Username and Password would be different for different users.

 d23

Figure 23. Enter your credentials

The dialog "The server certificate returned for IP address:port cannot be verified. Do you want to connect anyway?" might get displayed. Click on Continue as shown in Figure 24.

d24

Figure 24. The server certificate returned for IP address:port cannot be verified. Do you want to connect anyway?

The Chrome RDP gets connected to the Windows Server, as shown in Figure 25.

d25

Figure 25. Chrome RDP connected to Windows Server

Select Local Server in Server Manager as shown in Figure 26.

d26

Figure 26. Server Manager>Local Server

Scroll down for Services and search for MSSQLSERVER service, which should get listed, as shown in Figure 27.

d27

Figure 27. MSSQLSERVER Service

Select Services in Control Panel>Administrative Tools and the SQL Server (MSSQLSERVER) service is listed, as shown in Figure 28. Right-click on the service and select Properties.

d28

Figure 28. Services>SQL Server>Properties

The service properties including the service name get displayed, as shown in Figure 29.

d29

Figure 29. Service Properties

Summary

In this article we introduced using Toad for SQL Server with Google Cloud Platform and got started by creating a VM instance for SQL Server based on Windows server on Google Cloud Platform and connecting to the VM instance with Chrome RDS.  In subsequent articles we shall install Toad for SQL Server on the Windows Server and connect to the SQL Server instance running on the Windows server to explore the different features of Toad for SQL Server.

 

 

 

 

 

 

Tags: Toad for SQL Server

Deepak Vohra

Written by Deepak Vohra

Deepak Vohra is an Oracle Certified Associate, Oracle Database 10g, and Sun Certified Java Programmer. Deepak has published on OTN and in Oracle Magazine.