January 20, 2017 at 2:29 am
Hi All,
I have 2 SQL Server 2016 EE one is in my local data center and another one is on the cloud. users accessing local data center. now I want to configure always on between local server and cloud server for DR and HA purpose. both servers are not in same domain. so kindly suggest how to configure always on.
-- Ragu Thangavel<
January 22, 2017 at 3:03 am
Windows 2016 now provides domainless and multi domain clustering so you should look toward this first and then build your AG on top of that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2017 at 2:30 pm
Windows 2016 now provides domainless and multi domain clustering so you should look toward this first and then build your AG on top of that
Wow. I had not heard of this up until now. I know that SQL Server 2016 had a lot of new features to promote, but I am a little surprised this has not been marketed more. Finally an easy to failover/manage alternative to db mirroring in scenarios where domain membership was not a valid option!
Has anyone tried this out yet? Is management/failover of the AG similar to a traditional AG in SSMS or T-SQL?
Joie Andrew
"Since 1982"
January 22, 2017 at 10:11 pm
This was removed by the editor as SPAM
January 22, 2017 at 11:21 pm
Joie Andrew
"Since 1982"
January 22, 2017 at 11:57 pm
Yes I have been exploring the new cluster features in Windows 2016. I am planning an article to show a nondomain\workgroup cluster with Alwayson availability groups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2019 at 7:47 am
I have done this on my Laptop & blogged the same. Below is the link for the same.
https://www.chiranjeevivamsydba.com/search/label/Multi%20Domain%20Always%20on
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply