Post reply

configure always on in sql server 2016 with cross domain

  • January 20, 2017 at 2:29 am

    #334303

    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

    #1924241

    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

    #1924277

    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

    #1924300

    Jason, those links seem to point to how to add nodes to an AG in the same domain, not add nodes to an AG if the servers are in different domains or if servers are not in any domain at all.

    Joie Andrew
    "Since 1982"

  • January 22, 2017 at 11:57 pm

    #1924302

    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

    #2018837

    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