Thursday 22 November 2018

Create listener name SQLAWSDBLSTNR in Active Directory for Always On in SQL Server


Create listener name SQLAWSDBLSTNR in Active Directory as mentioned in below steps:

•       Open the Active Directory Users and Computers Snap-in (dsa.msc).

•       In Menu > View -> Advanced Features. (Otherwise, we would not see option explained in next steps)

•       Right click the OU/Container where we want the VCO to be created and click “New” -> “Computer”

•       Provide a name for the object (SBAWSFARDBLSTNR) and click “OK”:

•       Right click on the on the VCO which we just created and select “Properties”. Click the security tab and then click “Add”:

•       Enter the CNO (SQLAWSAG01) (Make sure to select “Computers” option in the “Object Types” window) and click “OK”. The CNO is a Cluster Name Object.

•        Give CNO “Full Control” over the VCO.

No comments:

Post a Comment