Azure

How To Create SQL Server 2019 Digital Machine And Use As Database Server With Minimal Price

Introduction

 

Often, after we create a digital machine in Azure, it’s created with a contemporary picture of the focused working system and no different software program is obtainable.

 

If the requirement is to provision a machine that can be utilized as a database server then we have to go forward and set up SQL server as a separate occasion inside that and in that state of affairs licensing value will likely be further with home windows server license.

Now we have now an choice to create a digital machine that may act as a database server and it comes with preinstalled SQL server picture at the price of a home windows server license.

 

Advantages

  1. We don’t have to pay the SQL server license further value individually because it comes with a home windows server license. Undergo pricing to get extra particulars.
  2. We are able to dissociate the PublicIP of the database server VM and use it as an built-in service with one other Azure service. Examine the beneath articles for particulars,
    1. How you can allow digital community integration in-app service
    2. How you can combine a database server with AppService by means of the non-public digital community

Steps to provision

  1. Go to {the marketplace} and seek for digital machines.

  2. Enter the values of the required fields.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  3. Click on on “see all photos” and search “SQL Server 2019 on Home windows server 2019” picture from {the marketplace}.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  4. Click on on subsequent and select the proper subnet below Networking Tab. I’ve chosen an current digital community “database-vnet” and subnet “Database-subnet” that I’ve created in my earlier article How you can allow digital community integration in app service in any other case you can even add a subnet to a digital community by clicking on “Handle subnet configuration”.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  5. Go forward with default values of different Tabs like “Disk, Administration, and Superior” and use the beneath settings in “SQL Server settings” TAB and go forward until “Evaluate and Create”. Login Identify and Password will likely be prompted as already set credentials below the “Primary” tab; you may go forward with default credentials then the identical credentials will likely be used for SQL Server. 

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  6. Deployment is in progress and takes 2-Three min to finish.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  7. Go to useful resource group as soon as the deployment is accomplished,

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  8. Choose “SqlDbVM” and replica the PublicIP of the VM,

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  9. Hook up with SQL Server Administration Studio of your native machine,

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  10. Hook up with Azure SQL server with the assistance of created digital machine PublicIP and create SQL server credentials.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  11. Now, we will join with our Azure VM SQL server.

    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

  12. To verify the connectivity, use the beneath queries to create a database, desk, and insert some information. We are able to insert and choose the information.

    1. create database EmpDB  
    2. GO  
    3. use EmpDB;  
    4. GO  
    5. create desk Worker  
    6. (  
    7.    EmpId int id (1,1) not null,  
    8.    [Name] nvarchar(50) null  
    9. )  
    10. GO  
    11. insert into Worker([Name]) values(‘Employee1’);  
    12. insert into Worker([Name]) values(‘Employee2’);  
    13. insert into Worker([Name]) values(‘Employee3’);  
    14. GO  
    15. choose * from Worker;  
    16. GO  
    How to create SQL Server 2019 virtual machine and use as database server with minimum cost

Observe

This connectivity is through public web which isn’t advisable, therefore we will dissociate the PublicIP from the machine as soon as we’re finished and use the VM through digital community as non-public. 

 

Conclusion


We have now efficiently created a database server in Azure that may be built-in with one other Azure Service. It’s a helpful service which is obtainable to scale back the price to some extent.

Tags
Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Close