Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How many IP numbers are required for a SQL server active/ active cluster setup also what in the case of an active/ passive setup? Correct me if I am wrong 2 for private network 2 for public network ...... 1 for virtual server IP 1 for SAN 1 for MSdtc

share|improve this question
    
SQL Server setup requires its IPs and then you have requirements for Windows Cluster setup. The documentation for both is well documented on MSDN and TechNet. –  Shawn Melton Oct 18 '12 at 0:49
add comment

1 Answer

You are correct

For Multi Instance SQL Cluster (active/active )

1 IP for Windows Cluster

2 IP for SQL Server Virtual Network Name (SQL instance on each node)

1 IP for MSDTC (this is optional however required if you use distributed transaction like linked server)

2 IP for public network (1 per node)

2 IP for heartbeat network (1 per node)

for Single Instance single cluster ( active/passive)

in above instead of two you will only need one IP address for SQL Server virtual network name

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.