How many ips are required for sql server 2008 R2 cluster installation on windows cluster 2008R2?

_{Friday, June 1, 2012 12:14 PM}

How many ips are required for sql server 2008 R2 cluster installation on windows cluster 2008R2?

i.e. public ip, private ip or virtual ip etc?

I have Windows 2008 R2 server enterprise edition & sql server standard edition 2008 r2.

I need to setup sql active-passive cluster. what requirements i need to provide windows admin team from my side as sql dba?

_{Wednesday, June 6, 2012 8:02 AM ✅Answered | 1 vote}

Public Network

• 1 IP for Cluster Name
• 1 IP per node for each defined Public Network (commonly 1 per node)
• 1 IP per MSDTC that you may required. MSDTC is not a pre-requisite for SQL or Failover Clustering but certain techologies (such as distributed transaction support) requires it. You can configure 1-Many Clustered MSDTCs depending upon requirements. Commonly one is put into each FCI Group. Note Windows 2008 supports local MSDTC on Cluster nodes too (though this is a configuration I never use for HA reasons).
• 1 IP per each SQL Failover Clustered Instance (FCI). Please note that in SQL Server 2012 Multi-Subnet clustering is supported so in that case, using that technology you may require 1 IP per subnet per FCI -obviously that is not your scenario though.

Private Network

• 1 IP per node for each defined Private Network (commonly 1 per node)

Storage Network (optional and used when Shared Storage is provisioned over iSCSI)

• 1 IP per node for each defined Storage Network (if iSCSI targets are used. SAN using HBA cards will not require this)

Regards,
Mark Broadbent.

Contact me through (twitter|blog)
Please click "Propose As Answer" if a post solves your problem
or "Vote As Helpful" if a post has been useful to you

_{Friday, June 8, 2012 4:41 AM ✅Answered}

Thank you all.

_{Friday, June 1, 2012 12:26 PM}

Resources                                                                Number of IPs

Private Network,i,e Heart Beat (one per node) -->2

Public Network (one per node)   ->2

MSDTC                                        ->1

Windows Cluster Name        ->1

SQL Server Cluster Name   ->1

In case for installing a Multi-instance Failover Cluster, then it should have additional SQL Server Cluster names and IP addresses.

refer-

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/d38796f6-ceae-4799-9f10-1c1fb7c84aaf

Rama Udaya.K ramaudaya.blogspot.com Please remember to mark the replies as answers if they help and un-mark them if they provide no help.