A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

If this option is blank, double-check to make sure you have installed the Reporting Service on your SCOM server, not on your SQL Server. Figure 8: Choose your Reporting Service instance.

4. Change Computer Name of node which will host the standalone SQL instance to old SQL Server Virtual Server Name 5. Reboot the server 6.

Choose the names of the multiple SQL Server instances on the "Named Instances" screen during installation. For example, create two instances named "CUSTOMERS" and "EMPLOYEES" to create separate ...

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...