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 SQL1 or 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 SQL1 or SQL2 from any client but can't ping SQLPROD1.
Beside this, everything else works in Always On. I can successfully fail-over and see databases on other node.
Can you please help