question

fnicholas avatar image
fnicholas 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
sql-server-2008networkfailover
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
SirSQL avatar image
SirSQL answered
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)
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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
0 Likes 0 ·
So if you are only installing a single SQL instance then you will only need one extra IP (for example the 10.46.33.177 that you listed here). If you were installing more than one you would need another IP for each instance that you install.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.