3750105 - SWPM - TCP Provider: No connection could be made because the target machine actively refused it. Dispatcher not starting.

You performed a SAP NW (SAP ERP) System Copy through database dependent method 'backup/restore'. The SAP system configuration goal is 'distributed' environment.

Once restore completed, SWPM system copy process run failed at 75% with system dispatcher process unable to come up:

SWPM times out while connecting to database instance db. The error details are:

----
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
C  (10061) [08001] [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.
C  
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]
C  (99) [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3281]

C  (10061) [08001] [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online
----

R3trans process test show the TCP connection from the SWPM process to the SQL Server database instance is fine, no connection error is returned:

R3trans -x and R3trands -d return with 00000

however, SWPM system copy process run stop at 75%.

SAP NetWeaver 7.x on Microsoft Windows Server OS/Microsoft SQL Server 'Enterprise Edition'.

SWPM, TCP Provider: No connection could be made because the target machine actively refused it, Dispatcher not starting, TCP port, static, dynamic, 1433, network protocol, TCP/IP, R3trans -d , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem