AG listener error

• roshanbi

  SSC Rookie

  Points: 35

  More actions

  March 23, 2023 at 2:55 pm

  #4164211

  Dear Support,

   

  could you please advise why error below prevents me from adding new AG listener despite 2 ips are in different subnets?

  ADDITIONAL INFORMATION:

   

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

   

  ------------------------------

   

  '10.104.1.xx' and '10.114.1.xx' belong to the same subnet. Only one IPv4 and/or one IPv6 address from each subnet is allowed. For an advanced configuration, see the Windows Server Failover Clustering (WSFC) administrator to create a customized configuration through the Cluster Manager. (Microsoft SQL Server, Error: 19451)

   

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.4261&EvtSrc=MSSQLServer&EvtID=19451&LinkId=20476

• Michael L John

  One Orange Chip

  Points: 26764

  More actions

  March 23, 2023 at 4:13 pm

  #4164228

  Are you trying to add a second listener?

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• roshanbi

  SSC Rookie

  Points: 35

  More actions

  March 23, 2023 at 5:31 pm

  #4164262

  yes

• Michael L John

  One Orange Chip

  Points: 26764

  More actions

  March 23, 2023 at 5:58 pm

  #4164265

  This article spells it out pretty well.

  https://techcommunity.microsoft.com/t5/sql-server-blog/how-to-create-multiple-listeners-for-same-availability-group/ba-p/384028

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/