SSIS error: Login failed for user NT AUTHORITY\ANONYMOUS LOGON Simplest solution is to login using remote desktop to SSIS server and then run it using SSMS there Other option is to define SQL Agent job on the SSIS server and then run the package using this job Ultimate solution will be to configure Kerberos and allow double-hop connections on the SSIS box
database - SSIS connection manager login fails - Stack Overflow So when you type in the password and hit the button "test connection" it all works fine But when you run in debug mode (or in production), you don't have a password Therefore, of course, the login fails This is why you need a configuration file See my answer here:
login failed for user sa in sql server ssis - Stack Overflow An OLE DB record is available Source: "Microsoft SQL Server Native Client 11 0" Hresult: 0x80004005 Description: "Login failed for user 'sa' " An OLE DB record is available Source: "Microsoft SQL Server Native Client 11 0" Hresult: 0x80004005 Description: "Cannot open database "DB_DATA" requested by the login The login failed "
Error Running DTEXEC 64 bit from command line - Stack Overflow I'm migrating all my SSIS packages and solution to Visual Studio 2022 When I try the packages inside visual studio they run ok without problems But when I try it from cmd and I get this error: