Scot - your suggestion worked. I had to enable the MSDTC service and now the distributed queries run.

Thanks for the pointer !

🙂