How to enable/force Microsoft SQL Availability Group Listener IPs to register Reverse DNS?

Question

I have a few Availability Groups and would really like to have their Listener IP Addresses register reverse DNS, is there a setting I missed to enable this? (forward dns works as expected).

SQL Server 2016, Microsoft Server Std. 2016

score 2 · Accepted Answer · edited Nov 14 '17 at 21:08

2

Launch Windows Failover Cluster Manager.

Under Roles, right click on the entry under "Server Name" in the bottom pane. Select Properties. On the General Tab, check the "Publish PTR Records" checkbox. (Sorry for the crappy screenshot)

Edit: Powershell

Get-ClusterResource | where-object {$_.ResourceType.name -eq "Network Name"} | Set-ClusterParameter -Name PublishPTRRecords -Value 1

Screenshot

edited Nov 14 '17 at 21:08

Jacob Evans

7,636
3
25
55

answered Oct 18 '17 at 17:39

Chris Satola

332
2
6

Any way to do it with powershell? – Jacob Evans Oct 19 '17 at 23:49
The DBA's finally tested it, my firewall logs appreciate you. – Jacob Evans Nov 14 '17 at 15:36

How to enable/force Microsoft SQL Availability Group Listener IPs to register Reverse DNS?

1 Answers1