snippetsqlMinor
How do I change SQL Server 2012 Availability Group DNS subdomain?
Viewed 0 times
2012groupsqlsubdomaindnsavailabilityhowserverchange
Problem
Questions: how can I get my availability group to be registered as
Setup: my SQL Server 2012 availability group is on multiple subnets, similar to what's described at in this MSDN blog article. When I go into Failover Cluster Manager, it shows that name resolution is not yet available:
I then right-click "Name: ag-ewgtest" and choose properties. I check off "Publish PTR records" and it shows me that the full name is
The problem I have is that I'm only being allowed to update the DNS zone
I've tried updating my NIC as:
But hasn't made a difference. How can I change the subdomain that my availability group tries to register itself in?
ag-ewgtest.sql.company.com given that my server thinks of itself as server.company.com.Setup: my SQL Server 2012 availability group is on multiple subnets, similar to what's described at in this MSDN blog article. When I go into Failover Cluster Manager, it shows that name resolution is not yet available:
I then right-click "Name: ag-ewgtest" and choose properties. I check off "Publish PTR records" and it shows me that the full name is
ag-ewgtest.company.com.The problem I have is that I'm only being allowed to update the DNS zone
sql.company.com. If I change the DNS name to be ag-ewgtest.sql.company.com then the full name becomes ag-ewgtest.sql.company.com.company.com.I've tried updating my NIC as:
But hasn't made a difference. How can I change the subdomain that my availability group tries to register itself in?
Solution
The Availability Group Listener name is a Computer Name Object (CNO) in Active Directory, not just a DNS entry:
http://technet.microsoft.com/en-us/library/ff367878(v=exchg.150).aspx
Its location in AD determines where it gets registered. If you want to create a different one somewhere else, you can create a DNS CNAME (alias) pointing to the real Availability Group Listener name:
http://technet.microsoft.com/en-us/library/ff625726(v=ws.10).aspx
http://technet.microsoft.com/en-us/library/ff367878(v=exchg.150).aspx
Its location in AD determines where it gets registered. If you want to create a different one somewhere else, you can create a DNS CNAME (alias) pointing to the real Availability Group Listener name:
http://technet.microsoft.com/en-us/library/ff625726(v=ws.10).aspx
Context
StackExchange Database Administrators Q#40915, answer score: 5
Revisions (0)
No revisions yet.