How many IP Addresses we require for setting up ActiveActive SQL Server cluster with Analysis services?

Started by Dwayne, January 27, 2017, 09:10:14 PM

Previous topic - Next topic

Tom

Hi, I'd like to ask you a big question to submit because I can not find the answer elsewhere, how many ip addresses we require for setting up activeactive sql server cluster with analysis services? Thank you please to give me your help is urgent.

Rocco

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)