Would it be possible to improve upon the existing SQL connection to support connecting to a non-local server using integrated security i.e. trusted connection?
I'm afraid that this cannot be done because, apparently, the Trusted Connection policies on the remote machine restrict the connection. We cannot override security polices imposed by the remote machine.