HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How do I change SQL Server 2012 Availability Group DNS subdomain?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
2012groupsqlsubdomaindnsavailabilityhowserverchange

Problem

Questions: how can I get my availability group to be registered as 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

Context

StackExchange Database Administrators Q#40915, answer score: 5

Revisions (0)

No revisions yet.