I am trying to understand one thing. I have a application server that talks 2 back end databases on SQL always on.
when I look at the configuration ; I see that one of the databases uses listener name, lets say Listener_Prod, in connection string and the other database was configured to use Hostname of the one of the nodes as connection value for some reason.
Our DB was saying that we are going to configure second DB to use listener as well.
here is my question: If I configure the second DB to use listener_Prod and first DB is already using same listener name, then how connection will find its way to respective Database.
( different port maybe used in connection string ? ), how SQL always on route incoming connection to the right DB if listener name is the same for same always on group