vNext CTP 2.0 Cluster-less 创建AG报错
消息 19417,级别 16,状态 2,第 57 行
An attempt to fail over or create an availability group failed. This operation is not supported when Always On Availability Groups is running under a remote Windows Server Failover Clustering (WSFC) cluster context. Under a remote cluster context, failing over
or creating availability groups are not supported.
指令:
CREATE AVAILABILITY GROUP MyAG
FOR DATABASE Demo
REPLICA ON
'N1' WITH
(ENDPOINT_URL = 'TCP://N1.noad.com:7022',
AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
FAILOVER_MODE = MANUAL),
'N2' WITH
(ENDPOINT_URL = 'TCP://N2.noad.com:7022',
AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
FAILOVER_MODE = MANUAL);
环境:
Win 16+vNext CTP 2.0
已建相同服务帐号sql,密码一致,且已加入Administrators
不建群集,在SQL SERVER配置管理器里可以勾选启用AlwaysOn,但CREATE AVAILABILITY GROUP时报错。
文档上CTP 1.3就说支持Cluster-less,难道仅支持跟LINUX上AG?都是Windows Server却不支持?
看起来是自己姿势不对。。。
后来再测试,建个群集,创建AG就OK了。
Try SQL Server 2008 QQ:315054403 dgdba@hotmail.com