July 18, 2022 at 2:55 pm
Hi I've been asked to extend a HAG which is currently on premise to include an azure vm sql instance.
currently i have a 3 node cluster, two nodes in on city with synchronous connect and auto failover and one in another city with asynchronous connect and manual failover. I want to add an azure vm with asynchronous connect and manual failover.
The Failover Cluster Manager lets me add the azure vm but when i try to add the Azure server to the availability group it joins but will not connect.
Has anyone done this yet ? I did have issues with the azure server only being visible to parts of the network but it is now visible across the whole domain and port 1433 and 5022 are open and accessible .
Trouble shooting info from MS only seems to talk about an all on premise cluster or all azure based clusters, so I'm really trying to find any guidance on how to set one up that is a hybrid of cloud and on premise.
July 18, 2022 at 8:11 pm
Have you seen these:
http://tech-trainer.info/extend-alwayson-sql-cluster-in-azure-step-by-step/
I have not set this up myself - but will be looking to do something similar once we are able to upgrade to SQL Server 2022.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 19, 2022 at 8:18 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply