Reaching a Microsoft SQL Server 2017 cluster from another device
Assuming the MSSQL cluster is setup on windows, it will have a virtual IP address which is different than the IP addresses assigned to each node. This virtual IP address will always point to the active node. The application can connect to the SQL server using this virtual IP address.