Eric M Russell (6/29/2016)
Phil Parkin (6/28/2016)
Eric M Russell (6/28/2016)
Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server.- First confirm you can at least ping the SQL Server instance, both from your PC and from the SSIS server.
- Next, attempt to connect via SSMS, both as yourself and by logging in using SQL Agent account credentials.
- Next, RDP into the database server and confirm mssql service and browser service as up and also confirm nothing unusual with firewall, etc.
Really? Even though the error message contains this:
The AcquireConnection method call to the connection manager "Target" failed with error code 0xC0202009
From what I've seen, 0xC0202009 is more of a generic error for failure to connect. The other error messages in the stack seemed to suggest that the connection manager was not locating the server instance which is why I suggested focussing first on the status of the remote server itself.
Sure. It was your reference to 'source database server' that confused me.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.