When you create a new Availability Group there are a couple of administrative tasks that should be completed before creating your Availability Group within SQL Server. This will elevate any domain permission issues when you are trying to create your Availability Group and listener.

DNS entries:

1. This should be completed by your system administrator or someone who knows what they are doing and has the correct domain privileges.

2. Open DNS Manager. There should already be an entry for your windows cluster under your OU (organizational unit).

dns manager cluster OU

3. Add a static Host(A) entry for the listener.

static Host(A) listener

Windows Failover Cluster Manager:

Windows Cluster name: Cluster1

You can find the cluster name within Windows Cluster Failover Manager. In the example below, the cluster name is cluster1. The only nodes (servers) that are listed should be the servers you want to create as your primary and secondaries. Do not add other servers, since we do not want those servers affecting your cluster. The cluster should be created and running without errors.

windows cluster failover manager

Active Directory:

SQL Server Instance name (listener) – NEW: DistListener

You can name your listener anything you want. Make it meaningful so you know that listener goes with that Availability Group (if you have more than one AG and more than one listener) or a set of servers.

Create the Active Directory Object and give permissions to the Windows Cluster name ahead of time. This should be done first so the creation of the Availability Group and listener goes smoothly.

1. This should be completed by your system administrator or someone who knows what they are doing and has the correct domain privileges.

2. Connect to a server that has “Active Directory Users and Computers” installed. Your domain controller will have it installed. Other servers can have it installed but you have to add that windows feature.

3. Open Control Panel, System and Security, Administrative Tools, then Active Directory Users and Computers.

control panel active directory

4. Locate the same AD OU that contains the servers and the windows cluster name (Cluster1). This will be located under Computers.

computers cluster AD OU
cluster1 computer

5. Create a new computer for the SQL Server listener name in this same OU: DistListener.

distlistener new computer

6. Open the new object:  DistListener, go to the Security tab.

7. If you do not see the Security tab, go to View, Advanced Features. This will now allow you to see the Security Tab.

advanced features security tab
view advanced features

8. Choose ADD and enter the name of the Windows Cluster: Cluster1.

add window cluster name

9. While still there, click Object Types… then Computers. Click OK. Click on windows cluster name: Cluster1$, click Check names then OK. Give this FULL CONTROL permissions.

object types full control
object names check names
user names full control

10. Choose OK.

11. This gives the windows cluster object the permissions to bring the SQL Server Listener object online and control in the context of the cluster.

12. LAST: Very important: Locate the new object for DistListener, right click and choose DISABLE.

distlistener disable account

13. The new object must be created but disabled so that during the creation process it can use it only if is not in use.

new object disabled
Share This