Sample Header Ad - 728x90

How do SSIS connection strings send passwords?

2 votes
1 answer
4342 views
I have a SQL server that pulls data from another SQL server via SSIS. We recently converted the server targeted by SSIS to VM. Since the VM conversion I have been getting "login failed for user '(username)'.". errors and the SSIS package fails to run. The connection string of the SSIS package indicates the username (which is correct for the target DB), but I do not see how it passes the password to connect to that DB and pull that data. So how does SSIS send passwords if not in the connection string? The Package Protection Level is set to EncryptAllWithPassword enter image description here Windows Authorization only option to run. SSIS Execute package utility
Asked by mcv110 (75 rep)
Apr 15, 2021, 06:10 PM
Last activity: Apr 22, 2021, 02:25 PM