Sql servr 2014 instant to sql server 2008 r2 instance linked servers query problem I'm getting the following error  on some of the linked server,when I try to query a table using a link server. The link server is created on SQL2014 instance to connect to an SQL2008r2 instance.
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.