Thanks for all the replies.

I got it to work by making it a linked server. I found the wizard to be less than intuitive but I got it to...