Post reply

Basic Avaialbility without active Directory

  • September 11, 2019 at 10:48 am

    #3679064

    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-Custer: 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?

  • September 11, 2019 at 5:19 pm

    #3679246

    Check the event logs for any errors as well as check the NICs to make sure File and Print Sharing for Microsoft Networks and Client for Microsoft Networks are enabled. Often you need to run winrm quickconfig to enable permissions for remote Powershell access as well.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply