asked
SQL SERVER Cluster Network Configuration
I am currently setting up a window failover cluster for sql server 2008. I have already assigned a static IP for the Window Cluster (The "Access Point for Administrating the Cluster" dialog box). The IP address I assigned is 10.46.33.174. I take it that this is the Virtual IP that will be used to administer the two node window cluster. Now, Half way installing SQL server, I was asked to assign an IP on the SQL SERVER "Cluster Network Configuration" dialog box. Should I assign the Window Cluster IP of 10.46.33.174 above or just I assign a different new static IP address? I look forward to hearing from you. Thanks, Francis
You need to assign a new IP address for SQL Server. You'll have IP's: - 1 each for the physical nodes (so total 2 in your case) - 1 for the cluster - 1 for each SQL Instance that you want to deploy (so 1 here)
Thank you for your answer. Please what do you mean by "1 IP for each SQL Instance" Right now - Here is my setup: Node 1 - 10.46.33.170 Node 2 - 10.46.33.171 Cluster Virtual IP for Node 1 & Node 2 - 10.46.33.174 So for your answer, I take it that can I cannot assign 10.46.33.174 on the SQL SERVER "Cluster Network Configuration" dialog box. I will need to assign a new different static IP address, say 10.46.33.177 I look forward to hearing from you. Thanks, Francis
8 People are following this question.
