I have a Passive/Active SQL Server 2008 cluster running on Windows Server 2008 (both are enterprise editions).
I have a server in the DMZ, I'll call it [Server A]. The cluster is named [CN] with nodes [CNA] and [CNB].
Inside our network, everyone connects to the server via named pipe, named [CNSQL] like such...
All ports are open inside our secure zone, all servers inside the the secure zone are numbers 192.168.1.* (not really, but I don't want to give out true IPs)
We are now adding a web application in our DMZ, which is on (so my network people tell me) a different subnet. We want the web app server to connect to the cluster. By default, all the ports are closed (DMZ cannot communicate with servers inside secure zone) unless I give them an exception list of every port to open on the web application server. We have other servers like this. The also do not have DNS for the secure zone, all servers are accessed via 10.0.1.* instead of their secure zone IPs of 192.168.1.*.
So, what do I need to do to get my DMZ'd web app server to connect to a SQL Cluster in a different network.
I'll take any ideas. Thank you very much.