I would check 2 things:
1) On your SQL Server, have you allowed remote connections to the server?
2) In your linked server set up, did you set the Data Access to true?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience