 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / September 2006publishing active/active sql server
Hi all, I have a 2-Node Active/Active SQL2000/SQL2005 Cluster sitting behind an ISA box. The SQL2000 which is a non-named intance i.e. default uses port 1433. I checked this through the SQL 2000 Server Network Utility. I then checked the SQL2005 named instance using the SQL Server Configuration Manager for 2005. TCP/IP is enabled and Listen All is set to Yes. Additionally, under the IP Addresses tab it shows the 3 IP addresses of the server (doesnt show the Virtual IP address of 172.19.2.42). Under IPAll - Dynamic Port is set for 1248. My question is I need to publish these 2 servers in ISA, so that servers in my DMZ can access them. What IP addresses and ports do I use? When we setup the cluster we had setup 2 Virtual IP Addresses - 172.19.2.41 and 172.19.2.42. How can I tell which server is bound to which IP? Further, in the case of SQL2005, how can I tell what port to use? Any help here is much appreciated! TIA! For firewall purposes, publish the IP addresses and the ports actually used by the SQL instance. In this case, they are the cluster virtual server IP addresses that are used by the two SQL instances and the actual port numbers of the two instances can be found in their respective errorlogs. Linchi > Hi all, > [quoted text clipped - 17 lines] > > TIA! Hello Param, Using the Cluster administrator you can see which Virtual Ips are in the same group as which SQL Server instances. Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > For firewall purposes, publish the IP addresses and the ports actually > used by the SQL instance. In this case, they are the cluster virtual [quoted text clipped - 27 lines] >> >> TIA! Gotcha. However, how can I tell which port to publish for SQL2005? 1248? TIA! > Hello Param, > [quoted text clipped - 36 lines] >>> >>> TIA! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.