On-Premises SQL HA Availability with Azure SQL

Nitin Arora 25

@GitaraniSharma-MSFT
I am wondering if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs. Please validate two scenarios below. SQL Always on 2

SQL Always on

GitaraniSharma-MSFT 47,421 Reputation points Microsoft Employee

2024-01-02T09:26:52.79+00:00

@Nitin Arora ,

I understand that you would like to know if it is possible to create a SQL Always On Availability Group with on-premises servers and SQL Azure VMs.

I work with Azure Networking products, so we should wait for the SQL team/experts to provide insights on this question.

However, as answered by @Sreeju Nair below, it seems to be possible.

Refer: https://learn.microsoft.com/en-us/previous-versions/azure/virtual-machines/windows/sqlclassic/virtual-machines-windows-classic-sql-onprem-availability

Regards,

Gita
v-vvellanki-MSFT 3,815 Reputation points Microsoft Vendor

2024-01-04T05:31:44.3233333+00:00

Hi @Nitin Arora ,
Just checking in to see if the below answer provided by Sreeju Nair helped.\r\nIf this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Nitin Arora 25 Reputation points

2024-01-15T09:07:14.13+00:00

@Sreeju Nair thanks for the reference! We successfully set up a SQL Always On availability group between on-premises and Azure. We're currently connecting through the AD-provided listener domain name. I have attached the infrastructure architecture for your reference.

My question is: can we also connect the listener using its public IP address? Thanks, Nitin
Nitin Arora 25 Reputation points

2024-01-17T09:23:58.37+00:00
GitaraniSharma-MSFT,

Hi Gitarani,

As discussed earlier, we created sql ag cluster and listener successfully, Please validate following queries.

connectivity from non ad joined device to listener is possible through SSMS.

connectivity possible between web application(host on ubuntu) and ag listener.

Currently facing issue while connecting from Ubuntu using Python code, screenshot attached for your reference. Kindly provide solution for listener connectivity from Linux environment.

error1.png

When we trying same thing on ad joined device, no issue found in connectivity. Python Script : HA.PY.txt

Thanks,

Nitin

1 answer

Sreeju Nair 11,611 Reputation points

2024-01-02T05:04:14.5166667+00:00

Yes, it is possible to extend the on-premises Availability Groups to Microsoft Azure by provisioning one or more Azure VMs with SQL Server and then adding them as replicas to your on-premises Availability Groups.

Refer: https://github.com/Huachao/azure-content/blob/master/articles/virtual-machines/virtual-machines-sql-server-extend-on-premises-alwayson-availability-groups.md

Hope this helps
Please sign in to rate this answer.

0 comments No comments
Sign in to comment