none
AG without WSFC not working

    Question

  • Hi,

    I would like create az availability group without Windows Server Failover Clustering.

    I have a primary server and a secondary with SQL Server Enterprise 2017.

    I have done availability group but when I trying join secondary server to the group it is drop an error: "An attempt to fail over or create an availability group failed. This operation is not supported when AlwaysOn 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. (Microsoft SQL Server, Error: 19417)"

    I cannot what I can do it. Please help me!

    Thursday, December 07, 2017 12:52 PM

All replies

  • Hi Stuli3,

    Could you please tell us how did you create the cluster-less Always-on? Have you specify the command option – “Cluster_Type = NONE” when you create the AG?

    Please refer to this blog to get more information: http://www.sqlmastersconsulting.com.au/SQL-Server-Blog/sql-server-2017-read-scale-out-availability-group

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, December 08, 2017 1:47 AM
  • This was the create script:

    CREATE AVAILABILITY GROUP [AG_wo_cluster]
    WITH (
    	AUTOMATED_BACKUP_PREFERENCE = SECONDARY,
    	DB_FAILOVER = ON,
    	DTC_SUPPORT = NONE,
    	CLUSTER_TYPE = NONE,
    	REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT = 0
    )
    FOR DATABASE [teszt]
    REPLICA ON N'TESZT-SERVR1\AG_TESZT' WITH (
    	ENDPOINT_URL = N'TCP://TESZT-SERVR1.xxx.com:5023',
    	FAILOVER_MODE = MANUAL,
    	AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
    	SESSION_TIMEOUT = 10,
    	BACKUP_PRIORITY = 1,
    	SEEDING_MODE = AUTOMATIC,
    	PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL),
    	SECONDARY_ROLE(ALLOW_CONNECTIONS = NO)
    ),
    N'TESZT-SERVR2\AG_TESZT' WITH (
    	ENDPOINT_URL = N'TCP://TESZT-SERVR2.xxx.com:5023',
    	FAILOVER_MODE = MANUAL,
    	AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,
    	SESSION_TIMEOUT = 10,
    	BACKUP_PRIORITY = 100,
    	SEEDING_MODE = AUTOMATIC,
    	PRIMARY_ROLE(ALLOW_CONNECTIONS = ALL),
    	SECONDARY_ROLE(ALLOW_CONNECTIONS = NO)
    );

    Friday, December 08, 2017 2:04 PM
  • Have you seen this article that addresses clusterless AAG setup?
    Always On Availability Group with no Underlying Cluster in SQL Server v.Next

    If you're on early or RTM version of SQL2017, consider applying CU2 thus, updating to build # 14.0.3008.27.

    Hope that helps,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Edited by philfactor Friday, December 08, 2017 10:27 PM
    Friday, December 08, 2017 3:48 PM