Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 477
  • Last Modified:

SQL server 2012 Fail over cluster and HA configuration

we need to configure SQL server 2012 with Failover cluster and HA without Active directory.

IF is possible?

Kindly suggest the best scenario without Active directory.
0
rigelnet
Asked:
rigelnet
1 Solution
 
PadawanDBAOperational DBACommented:
SQL Server 2012's Failover Clustering and AlwaysOn HA Groups rely on windows server failover clustering, which requires a domain and domain controllers, so I would have to say that those two options are not possible.  You can use replication with SQL Server authentication as an alternative, though. (http://technet.microsoft.com/en-us/library/dn505754.aspx)
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
That is true, you MUST have ActiveDirectory in order to set up a Cluster Based HA.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now