Sample Header Ad - 728x90

SSIS Double-hop... how to solve?

0 votes
1 answer
479 views
I have what I assume to be a pretty standard setup: 1. ServerA running a web application as ServiceAccount1 2. ServerB running SSIS as ServiceAccount2. 3. ServerC hosting a network share that ServiceAccount1 has permissions to read from The web application initiates an SSIS package execution via SQL commands. The package tries to read a file from the network share and fails due to the double-hop problem (login failed on ServerC, "anonymous login". How can I get this to work? The SPNs are already there, and I've tried granting the delegation permission but SSIS refuses to forward on the credentials.
Asked by Spivonious (117 rep)
Apr 15, 2024, 08:08 PM
Last activity: Jan 20, 2025, 01:05 PM