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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy