Azure SQL VM high availability, Join Domain Issue

Muhammad Hammad Naeem 0 Reputation points
2024-01-31T12:49:42.7866667+00:00

I am trying to create an Azure SQL virtual machine with high availability. But it gives an error: Join the domain, After creating the VM, and it cancle all the next steps to create the failover clusterUser's image

I am using AADDS, and its DNS IP address is added to the virtual network. if it try to join the domain after connecting the VM, it is successful.

SQL Server on Azure Virtual Machines
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. deherman-MSFT 33,626 Reputation points Microsoft Employee
    2024-02-05T16:40:22.25+00:00

    @Muhammad Hammad Naeem

    We didn't hear back from you, but I am posting some possible causes and solutions. Let us know if you still need assistance.

    DNS Configuration:

    • Ensure that the DNS IP address of your Azure Active Directory Domain Services (AADDS) is correctly added to the virtual network.
    • Go to the Azure portal, select the virtual network (VNET) to which the client (endpoints) belongs.
    • Navigate to the DNS settings and change it from Microsoft DNS to Custom.
    • Specify the IP address of your domain controller and save the settings.
    • Reboot the virtual machine within that VNET.
    • Try joining the domain again; it should work1.

    VNET Peering:

    • If you have multiple virtual networks, ensure that the VNET containing the domain controller is properly peered with the VNET where your SQL virtual machine resides.
    • Add the DNS server’s IP address to the VM configuration.
    • This step is crucial for VMs that belong to a host pool, especially for services like Windows Virtual Desktop (WVD) or similar2.

    Detailed Error Message:

    • Please provide the detailed error message you receive during the domain join process. This information will help us diagnose the issue more accurately.
    • If you encounter any specific error codes or messages, share those as well.

    If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts. If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community. Thank you for helping to improve Microsoft Q&A! User's image

    0 comments