How to Create SQL Server on Google Cloud Platform.

SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

 

  • Login to google cloud platform portal.
  • Click on SQL.

 

Fig 1

 

  • Click on Create Instance.

 

Fig 2

 

  • Select SQL Server.
  • Then click on choose SQL server.

 

Fig. 3

 

  • Provide the Instance ID & Password.
  • Select Database version for instance.
  • Select Region & Zone.

 

Fig. 4

 

  • Click on Show Configuration Options.

 

Fig. 5

 

  • Click on Machine type.

 

Fig. 5

 

  • Select Machine type :Shared core, Lightweight, Standard (Most common) or High memory.

 

Fig. 6

 

  • Select Storage type & Capacity.

 

Fig. 7

 

  • Select Public or Private network for instance.
  • If needs to Add network click on Add network.

 

Fig. 8

 

  • Provide New Network name & Network IP.
  • Click on Done.

 

Fig.10

 

  • SQL server user authentication is available by default..You can also join an Active Directory domain for this instance.

 

Fig.9

 

  • Set the Backup.

 

Fig.10

 

  • At Maintenance, Select Preferred window & order of updates.

 

Fig.11

 

  • Click on Add Flag.

 

Fig.12

 

  • Provide the New database flag name.
  • Click on done.
  • Select Default collation.

 

Fig.14

 

  • Click on Add Label.

 

Fig.15

 

  • Provide Key name & value for SQL Server.
  • Click on done.
  • Then click on Create instance.

 

Fig.16

 

  • After sometime database is ready then go to SQL Server instance page.
  • SQL Server instance is there with the name we provide.

 

Fig.18

 

Leave a Reply