In this blog post, let’s learn about the error message “19460 – The availability group listener with DNS name ‘%.*ls’ is configured to use DHCP. For listeners with this configuration, IP addresses cannot be added through SQL Server. To add IP addresses to the listener, drop the DHCP listener and create it again configured to use static IP addresses.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
19460 – The availability group listener with DNS name ‘%.*ls’ is configured to use DHCP. For listeners with this configuration, IP addresses cannot be added through SQL Server. To add IP addresses to the listener, drop the DHCP listener and create it again configured to use static IP addresses.
Reason for the Error
To be update soon…
Solution
To be update soon…