SQLTeam.com | Weblogs | Forums

SQL Always On AG


#1

Hello

I have built a Two Node SQL 2014 Always on Cluster on the same subnet, Not multisubnet.

I need to create two availability Groups/listeners in the same instance for two set of databases. Do I need 2 separate IP address for each listener or one IP address can be shared for both Listeners ?

sqlrob


#2

Hi sqlrob,
You will need 2 IP addresses, as that is the only way you can separate the 2 groups of database(s). I assume that is your purpose of using always on :smile: