However, when you’re running SQL Server on-premises and configuring a hybrid architecture for DR, there are additional operational elements you should take into consideration.

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.

If you properly configure the SQL Server to trust accounts from another domain or server, then you can easily grant permissions to that account for access to the SQL Server as shown in Figure 4.