March 23, 2023 at 2:55 pm
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
March 23, 2023 at 4:13 pm
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/
March 23, 2023 at 5:31 pm
yes
March 23, 2023 at 5:58 pm
This article spells it out pretty well.
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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply