I am new in working with SSIS on SQL server. I deployed a package to my Test Server and trying to execute in Intergration service catalog to run the package and these are the errors i see every time i run it. I tried to schedule a job to run this and even that failed. I researched online but nothing helped. Any suggestions are welcomed. The package runs fine in BIDS. Thanks
Error:1 Trip:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E4D Description: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.".
Error:2 Trip:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error:3 Trip:Error: Source_A_production failed validation and returned error code 0xC020801C.
Error:4 Trip:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error 1:
The user NT AUTHORITY\ANONYMOUS LOGON does not required permissions to connect the DB. Please make sure that user has the rights to connect the targeter DB server.
Error 2:
The error says something is wrong with the credentials you are using to connect the db. Make sure your connection string looking like below:
"Provider=SQLNCL1;Data Source=xxxx;Initial Catalog=xxxxx;Integrated Security=SSPI;"
If you have to use a username and password, make sure they are correct.
Also, you can try to change ProtectionLevel
to EncryptSensitiveWithUserKey
. If still does not work, try to create a new connection manager and delete the old one.
References:
Error 3:
Do a right click on project in Solution Explorer in debugging and look at the Run64BitRuntime
property and toggle this to false
.
References:
Error 4:
Same as Error 2
User contributions licensed under CC BY-SA 3.0