Sql servr 2014 instant to sql server 2008 r2 instance linked servers query problem
What Provider are you using? Try the "Microsoft OLE DB Provider for SQL Server" or the "SQL Server Native Client". 
Also ensure the permissions in the linked server are correct, and that the account actually has access to the database on the remote server.