SQL Server AOAG on multi subnet cluster using the same AD
Hi All,
We have a SQL Server 3 node multi subnet cluster created having 2 node on production subnet and 1 disaster recovery (DR) node on another subnet but under the same domain/AD (One in Ohio and the other in NJ). What I know is that there should be another domain/AD on the DR site for this setup. Am I wrong ?. We have applied a second IP address on the AG Listener for the DR site but it is not connecting at all. What do we need to get this working ?. We cannot even ping the second IP from any of the nodes. Picked the Automatic seeding but it is not replicating at all. Some of the errors I got:
A connection timeout has occurred while attempting to establish a connection to availability replica 'SERVER01\PRODINST1' with id [83ECE30D-9ACB-47AA-82F9-F1AE77B3F55B]. Either a networking or firewall issue exists, or the endpoint address provided for the replica is not the database mirroring endpoint of the host server instance.
Always On: DebugTraceVarArgs AR '[HADR] [Primary] operation on replicas [83ECE30D-9ACB-47AA-82F9-F1AE77B3F55B]->[03C5AE4F-84E2-485D-8F84-7699E4B8CC7B], database [PROD1], remote endpoint [TCP://DRSERVER01.contoso.com:5023], source operation [0FE86A20-E6D7-4B9D-8BC5-83E4A10ED461]: Seeding encountered a transient failure, state '108', maximum retries exceeded'
Message
Automatic seeding of availability database 'Sample_Test' in availability group 'PROD1_AG1' failed with a transient error. The operation will be retried.
Any help will be appreciated. It is SQL Server 2019 with CU30 on Windows 2022 servers.
Carlos D.