I have an SSIS package in a SQL Server 2016 Integration Services Catalog on my server, SERVER1 (2016 SP1 CU4). Among other things, this package connects to SERVER2 (SQL Server 2008 SP2). The package recently started failing with the following error:
Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: No connection could be made because the target machine actively refused it."
What I've done/tried:
tcp:SERVER2as well as using just the IP address.
hostsfile on SERVER1
I don't have administrative permissions and can't log in interactively on SERVER2, so I can't check firewall settings, etc on that machine.
netstat on SERVER1 when the job runs, I can see that there's a process trying to connect to SERVER2 on port 1433 (with status
TIME_WAIT) but it never appears to connect.
My client recently added another named instance to SERVER1 and changed the TCP ports of the default instance, but he says he hasn't changed anything on SERVER2.