SSIS Deployment: SSIS Package run time error in SQL Server deployment

3

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.

sql
sql-server
tsql
ssis
ssis-2012
asked on Stack Overflow Feb 27, 2018 by Nani • edited Feb 27, 2018 by Eray Balkanli

1 Answer

0

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

answered on Stack Overflow Feb 27, 2018 by Eray Balkanli • edited Feb 28, 2018 by Yahfoufi

User contributions licensed under CC BY-SA 3.0