Virtual machine scale sets for web servers - back end SQL server AG

Azurebegginer 146 Reputation points
2020-05-28T08:17:38.73+00:00

Hello All,

Hope safe and well

We are planning to use VM scale set for web servers as front end and back end covered by SQL Server always on on VM.

I need help to understand the deployment of web servers on VM scale set.

  1. Deploy a VM with IIS and deploy the web site with code and connection string to back end SQL server
  2. Deply the VM to scale set.

Is this the right process??

Please advice

SQL Server on Azure Virtual Machines
Azure Virtual Machine Scale Sets
Azure Virtual Machine Scale Sets
Azure compute resources that are used to create and manage groups of heterogeneous load-balanced virtual machines.
363 questions
0 comments No comments
{count} votes

Accepted answer
  1. vipullag-MSFT 25,941 Reputation points
    2020-05-29T09:25:43.783+00:00

    @NeerajV-6011

    Below are few suggestions for your ask:

    If you have a custom image already built with all necessary configurations (IIS and DB connections), you can deploy that image to VMSS (VM can be deployed into VMSS only at creation time). And then can connect to SQL server. Here is the doc reference on this.

    Another consideration is to use Custom script extension. With this you can avoid building custom image every-time there is a change. You can have scripts to do the configuration on the VM. You can also consider using Azure Key Vault for storing DB string. Please refer this document.

    Also, below are few quick start templates that you can check:

    https://azure.microsoft.com/en-us/resources/templates/301-multi-vmss-linux-lb-zones/

    https://azure.microsoft.com/en-us/resources/templates/201-vmss-custom-script-windows/

    Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.


0 additional answers

Sort by: Most helpful