Solved

SQL server 2012 Fail over cluster and HA configuration

Posted on 2014-01-08
2
446 Views
Last Modified: 2014-01-21
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
Comment
Question by:rigelnet
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
Comment Utility
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
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
Comment Utility
That is true, you MUST have ActiveDirectory in order to set up a Cluster Based HA.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now