• Hi all, Thanks for all the help. Apologies to Jack because although I had read Kendall'sblog post I glossed over the hosts file suggestion. This is what I will try next.

    In response to others, the servers communicate, the host file allows server name resolution and I've validated the tcp connection via tenet.

    I think the problem is down to the lack of fqdn. So will try to create a fake one via the hosts file.

    Tom

    In SQL there are no absolutes, it always depends...