At the SQL Server instance level do you have the publisher and subscriber to "Allow Remote Connections?"
And in your linked server, have you enabled "data access"?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience