Does Changing the SQL Server Database Host to an FQDN Affect the Availability Group Configuration?

Question

If I change the Database host from an IP address to a fully qualified domain name (FQDN), does it affect my connection's Availability Group (AG) configuration?

Environment

Connector: SQL Server

Answer

No, updating the Datebase host from an IP address to an FQDN doesn't affect the existing AG configuration, as long as the FQDN points to the AG listener.

To update the hostname:

1. Confirm the FQDN points to the AG listener, not a specific SQL Server node.
2. In Fivetran, go to your SQL Server connection page.
3. Select the Settings tab.
4. Click Edit connection.
5. From the left menu, select Networking.
6. In the Database host field, enter the FQDN.
7. Click Save & Test.