troubleshooting Question

SQL Always on Listener

Avatar of Eric
EricFlag for Canada asked on
DatabasesMicrosoft SQL ServerSQL
3 Comments2 Solutions85 ViewsLast Modified:

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

Pavel Celba
All in One

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros