I installed SQL 2012 with Always on. It has 3 nodes.
Here is the detail information about the server:-
Server Name |
Failover Mode |
SQL Listener Name |
Node 1 |
Automatic |
ABCD |
Node 2 |
Automatic |
ABCD |
Node 3 |
Manual |
ABCD |
It seems application is having problem to connect the DB server with listener name; but application can connect the DB server with server name (i.e. Node 1/2/3). Do you know what would be the reason?
I also noticed when I tried to connect DB server through SSMS (by using SQL Listener name) it is taking too much time. I have to increase connection time-out to 60 sec otherwise it is throwing timeout error. But if I use server name then it is not throwing timeout error. I am not sure why it is taking more time to connect DB by using SQL Listener name. Any Idea?