DRS link shows “Link is being configured” between the primary site and secondary site in SCCM

Issue

DRS link shows “Link is being configured – Initializing data between the parent site and child site.” between the primary site and secondary site

Behaviour

hman.log on the secondary site –

Failed to get top level site code

The following query in the secondary site database to get information in transmission queue

SELECT * FROM sys.transmission_queue;

shows in transmission_status column the error message below –

Connection attempt failed with error: '10060(A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond)'

SQL Server error 10060 means –

The SQL Server client cannot connect to the server. This error could occur because either the firewall on the server has refused the connection or the server is not configured to accept remote connections.

The same query in the primary site database has no trances of messages coming from the secondary site.

Test the tcp connection to port 4022 of the primary site database from the secondary site database with PowerShell command –

Test-NetConnection <Primary-Site-DB-FQDN> -Port 4022

TCP connection is False. This indicates some network issue. It is probably that some network device can block the traffic traveling from the secondary site database to the primary site database.

Solution

Search with SQL Server error 10060, the following article is found –

https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error?view=sql-server-ver15

which provides the following solution –

• Make sure that you have configured the firewall on the computer to allow this instance of SQL Server to accept connections.
• Use the SQL Server Configuration Manager tool to allow SQL Server to accept remote connections.

That helps fix the issue.

References

• https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error?view=sql-server-ver15