I just setup SQL Server 2012 (on Windows Server 2012) Always On feature and have a problem with connecting to SQL Server Listener from non-primary node (it works from primary node though).
Here is the scenario:
2 nodes in different subnets: SQL1 10.0.2.11 (primary) SQL2 10.0.6.11 (secondary) Listener: Name: SQLPROD1 Port: 1433 Subnets IP address 10.0.2.0/24 10.0.2.102 10.0.6.0/24 10.0.6.102
I can connect to
SQLPROD1 in SSMS on primary node (either
SQL2) but can't connect (not even ping)
SQLPROD1 from secondary or from any other client in the network.
I checked firewall and it doesn't seem to be the cause of the problem. I can ping
SQL2 from any client but can't ping
Beside this, everything else works in Always On. I can successfully fail-over and see databases on other node.