• Look in the error log of the SQL instance where the linked server is connecting to. Are there any errors at the moment you ran your report?

    This could be related to a "double hop" problem. A short description and needed setup for this is on http://www.sqlservercentral.com/blogs/sqlsandwiches/2011/06/20/double-hop-of-doom/.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **