We have 2 SQL server 2016 servers that are having communication issues when setting up Availability groups and replication. The servers can ping each other and can be connected using a UDL file and an ODBC connection. Port query indicates both server can reach TCP port 1433 and UDP Port 1434. TCP and NP are configured on both servers in SQL Config Mgr. The server will both ping on IPv4 but not on IPv6. Work stations donot appear to be getting any connectivity error from either machine. The error being returned between the servers is:
Cannot connect to Reporting.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)
The specified network name is no longer available
This occurs when trying to set up an AG replica from our Production server to our Reporting server. It also occurs when setting up replication between the 2 servers. Can create distributor on either machine and get like errors regardless of location when trying to initialize the subscription.