i keep getting errors relating to my network when trying to access a sql server that is on my network
its a SQL CLUSTER consisting of 2 nodes (1 database instance, so its active/standby)
MS Failover clustering was setup correctly but i now see an error on my "cluster network 2" when i am in the failover cluster manager.
the status is PARTITIONED, the cluster use is ENABLED and the SUBNET is the network that i am logged into on the server via RDP, and the network that all the clients connect to the server.
the other network is a private network, which is used for iSCSI, because the database is located on a SAN (the status of that network is UP and the cluster use is INTERNAL)
the problem is that i will randomly get errors when trying to connect to the SAN stating that there is a network related problem of some sort. i would imagine that this is due to the second cluster network having a problem. i also CANT ping each node from the other node, although they are on the same subnet (consecutive IPs actually)
any ideas? maybe this has to do with an incorrect cluster setup? all users are connecting via DNS name, maybe the cluster is also trying to connect users to the standby node?