January 7, 2019 at 4:05 am
Hi,
I have an SSIS Package that transfers data from source server > target server. This is a straight table to table transfer from one DB to another.
The SSIS Package runs fine from visual studio, however when I run the package from the SQL Server Agent I get the following error: 'CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER' error related to the target server. Login Timeout Expired, Check if instance name is correct and if SQL Server is configured to allow remote connections. SQL Server Network Interfaces: Error Locating Server/Instance Specified'
I've been reading around online but have been unable to come up with a solution as of yet. I tried to transfer the data using the import/export wizard and that worked without any problems.
Any ideas what is causing the error when running the package using the SQL Agent?
Thanks.
January 7, 2019 at 5:05 am
mattdarvellwow - Monday, January 7, 2019 4:05 AMHi,I have an SSIS Package that transfers data from source server > target server. This is a straight table to table transfer from one DB to another.
The SSIS Package runs fine from the package, however when I run the package from the SQL Server Agent I get the following error: 'CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER' error related to the target server. Login Timeout Expired, Check if instance name is correct and if SQL Server is configured to allow remote connections. SQL Server Network Interfaces: Error Locating Server/Instance Specified'
I've been reading around online but have been unable to come up with a solution as of yet. I tried to transfer the data using the import/export wizard and that worked without any problems.
Any ideas what is causing the error when running the package using the SQL Agent?
Thanks.
The SQL Agent job probably runs in the context of the SQL Agent service user, which may not have the rights to connect to the target server.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply