Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Tom on January 27, 2017, 09:10:14 PM

Title: How many IP Addresses we require for setting up ActiveActive SQL Server cluster with Analysis services?
Post by: Tom on January 27, 2017, 09:10:14 PM
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.
Title: Re: Ip Addresses we require
Post by: Rocco on July 12, 2017, 08:36:13 PM
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)