Hi,

The linked server is set up to use the Windows login's current security context. On the face of it, Kerberos seems to be working ok. sys.dm_exec_connections shows several sessions using kerberos authentication and I can test the double-hop successfully.

In my SSIS package, I've set this step up as an execute sql task. It just runs the stored procedure on the remote server (as defined in the connection manager). Every other run fails with the nt authority logon error, which I fix by doing the linked server select query. If I run the stored proc by connecting to the server via SSMS on my local machine (the same pc I envoke the ssis package from) it runs successfully every time.

Cheers,

Andrew