Background: We plan to create a SQL AlwaysOn Availability Group cluster across multiple subnets. Therefore we're going to need the Windows 2008 R2 servers in this cluster to be able to update DNS dynamically (for fail-over situations). We run BIND DNS. We know that we can authorize DNS updates based on IP address. We also know that BIND supports DNS update authorization from DHCP keys.
Question: Can we install DHCP keys* on the Windows server so that we can authorize it to make DNS updates in BIND that way? If so, how?
* DHCP keys are also called transaction signatures (TSIG).