title: SSIS: Login failed for user 'NT AUTHORITY\ ANONYMOUS LOGON'
body: <p>Preface: SSIS packages are deployed on SQL server, say serv1, and in these packages connections are made,using windows authentication, to another SQL server, serv2. And</p>
  
  <ol>
  <li>I am using windows authentication, a domain account, to login on serv1</li>
  <li>This account also has login on serv2, although through different windows group</li>
  <li>SPN are registered for both SQL server's service accounts and delegation is ON.</li>
  <li>auth_scheme is kerberos. Although for service accounts <strong>NTLM</strong> is being used because network layer protocol is <code>Shared memory</code>. And for other domain accounts <code>kerberos, TCP</code> is being used.</li>
  </ol>
  
  <p>While executing these packages, they fail with error message <code>Login failed for user 'NT AUTHORITY\ ANONYMOUS LOGON'</code>. All solutions to this scenario point to <strong>Double Hop problem</strong>. Everywhere the solution includes the steps mentioned above. Is there anything that I am missing here.</p>