SQLTeam.com | Weblogs | Forums

Without Active directory -Alwayson

Hi ,

I am trying to configure Basic Allwayson in SQL 2016 Standard edition using the below ebsite

https://www.sqlpassion.at/archive/2016/01/11/how-to-create-a-sql-server-availability-group-without-an-active-directory-domain/

I did below things.

Firewalls off in both nodes SQL-1 & Sql-2

I created DNS Suffix in both servers as Testing.com

Remote registry and Remote administration is enabled in both nodes.

i enabled Failover clustering

In powershell command i tried this beow command

new-cluster -name sqlbag –Node SQL-1,SQL-2 -StaticAddress 1.2.3.4 -NoStorage –AdministrativeAccessPoint DNS

got below error:

New-Cluster: There was an error adding node SQL-1 to the cluster

failed to access remote registry on sql-1.Testing.com .. Ensure that the remote registry service is running and have remote administration enabled.The network path was not found.

Note :Remote registry and Remote administration is enabled in both nodes.

Please help how to resolve this?

Did you set up your host file entries? It's mentioned in the article about 1/4 of the way down.

SURE.I wil check