Creating a SQL Server instance using Google Compute engine

0 votes
Can somebody help me with the process of creating a SQL instance using compute engine on GCP?
Sep 23, 2019 in GCP by Karan
• 19,610 points

1 answer to this question.

0 votes

Google Compute Engine provides public images preconfigured with SQL Server. 

To create a SQL Server instance, specify the image family for the specific version of SQL Server that you need.

To create a SQL Server instance:

For images with SQL Server, you must select SQL Server images from the Applications tab.

  1. In the GCP Console, go to the VM Instances page.

  2. Click Create instance.

  3. In the Boot disk section, click Change to begin configuring your boot disk.

  4. On the Application images tab, choose a SQL Server image.

  5. Click Select.

  6. Click Create to create the instance.

After you create the instance, create a firewall rule to allow access to SQL Server on your instance. 

The default SQL Server port is 1433.

  1. In the Cloud Platform Console, go to the Firewall Rules page. In the GCP Console, go to the Firewall Rules page.

  2. At the top of the page, click Create firewall rule to start creating a firewall rule.

  3. Specify the details for this firewall rule.

    • In the Name field, specify a name for the firewall rule.

    • In the VPC network field, select the VPC network where your SQL Server instance is located.

    • For the Direction of traffic, select Ingress.

    • In Source filter field, select the range of IPs that you want to allow access on this port. For this example, you can select Allow from any source.

    • In the Allowed protocols and ports section, enter the port that SQL Server uses. For this example, specify tcp:1433; which is the default port.

  4. Click Create to create this firewall rule and allow access to your SQL Server instance over port 1433.

If you need to add additional firewall rules to your instance, see the firewall rules documentation.

answered Sep 23, 2019 by Sirajul
• 59,230 points

Related Questions In GCP

+1 vote
2 answers

How to open a port on google compute engine

You need to set the firewall rule ...READ MORE

answered Jul 10, 2019 in GCP by K sagar
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How do i install gcloud compute?

The gcloud compute command-line tool enables you to easily ...READ MORE

answered Sep 23, 2019 in GCP by Sirajul
• 59,230 points

edited Jun 16, 2023 by Khan Sarfaraz 1,084 views
0 votes
1 answer

Creating password for a windows instance on GCP

Windows Server instances use password authentication instead ...READ MORE

answered Sep 24, 2019 in GCP by Sirajul
• 59,230 points
0 votes
1 answer

Create a Windows VM instance using Google Compute Engine (GCE).

To create a Windows virtual machine instance ...READ MORE

answered Sep 20, 2019 in GCP by Sirajul
• 59,230 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP