37.Azure creating a SQL on winsrv virtual machine (top)

Tag: Cloud Platform for Cloud computing

If you are preparing a SQL Server in the traditional way, it is necessary to install the Windows Server System first, then install SQL Server roles and features required, and then install SQL Server, so the installation steps are cumbersome and complex, Preparing such an environment for a person unfamiliar with the system can be quite laborious, so is it complicated to prepare such a SQL virtual machine on Azure? The answer is very easy,azure provides two types of SQL services, one is the SQL on Windows server virtual machine type, which means that the creation of the type of virtual machines automatically loaded SQL Server, without the user to prepare the SQL installation files for installation, the very aspect The other is the SQL service for the PAAs layer, no virtual machine management, only the database, accessed through the Microsoft SQL Server Management Studio connection. The 2 most intuitive difference is that you need to manage virtual machine +sql, which you only need to manage SQL. This article mainly introduces the former one.

Or as before, create the virtual machine, but select the virtual machine image is SQL on Windows Server

Enter the virtual machine name and the virtual machine user name password, as well as the resource group

Select Virtual Machine Size

Create an availability Set

I chose the previous storage account

I choose the virtual machine is a dynamic public IP address

Click OK

The next step is only SQL on the Windows server image, choose how to link sql: Local means only allow the virtual machine can access SQL; Specifically, it means that only the machines on the Azure virtual network subnet where the virtual machine resides can access the SQL Public means that SQL can be accessed over the Internet.

Here you choose whether to enable the SQL authentication method, which is the SA account that we used to be familiar with, but here is your own definition sa account name (and the virtual machine account name password can be different), you need to define this account and password; Set the storage configuration for SQL: size and type

Create

Wait for creation to complete before using

Because I am a dynamic public network IP address, the public IP address will change after the virtual machine restarts, so I need to set a DNS domain name

Next, you can access it through the Microsoft SQL Server Management Studio connection, MSSM

Https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Log in locally using the DNS name that I have defined so that the dynamic public IP changes are not feared

Login on the

Create a new database

37.Azure creating a SQL on winsrv virtual machine (top)