SQL server 2012 always on without a domin

Question

Hi all,

   Is it possible if I install and configure a SQL server always-on group without a domain, for example, just on a workgroup?

Thanks.

-Regards,

Aaron

---

jun

Answer 1

Since AlwaysOn uses Windows Failover Clustering you will need the hosts to be in a AD domain. There is a similar post here...

http://www.sqlservercentral.com/Forums/Topic1091310-391-1.aspx#bm1091619

...and Brent Ozar's blog page...

http://www.brentozar.com/archive/2012/03/why-availability-groups-make-cool-again-be-sysadmin/

...states for AlwaysOn Availability Groups: "The Windows Server instances must be part of a domain".

Thanks

Answer 2

Hi There,

you can not enable always on feature on a standardalone instance wather it is in domain or standard alone machine.

TO enable this feature the machine you wanted to install SQL instance should be part of your windows cluster. Then you get an option to enable.

goodluck.

kumar