• May I ask, are you connecting to server 2 with windows or sql authentication? Can you set up a linked server on server 1 to the subscription server with the same credentials?

    'Only he who wanders finds new paths'