Tuesday, November 13, 2012 2:35 AM
Is it possible if I install and configure a SQL server always-on group without a domain, for example, just on a workgroup?
Tuesday, November 13, 2012 3:04 AM
Since AlwaysOn uses Windows Failover Clustering you will need the hosts to be in a AD domain. There is a similar post here...
...and Brent Ozar's blog page...
...states for AlwaysOn Availability Groups: "The Windows Server instances must be part of a domain".
Wednesday, November 14, 2012 9:14 PM
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.