Hello Jeff, I came across your presentation while researching the evils of using GUIDs as PKs and to say it was very informative would be an understatement. Do you know...

THANKS !!!

It was the extra single quotes giving the problem, got carried away with them for sure. (staring at the screen for too long...)

Yes remote connections are successful and Ad Hoc Remote Queries are enabled.

Named Pipes are also enabled.

It is not a default instance so I then tried:

SELECT * FROM OPENROWSET('SQLNCLI','Server=''server\instance'';

...

I still get the same error