title: SQL Server 2012 Linked Server Connection Issue
body: <p>I have a local SQL Server 2012, and a vendor has a remote SQL Server 2012 setup for us with a read only SQL user. The vendor will do nothing except provide this read only login.  I can login and query with remote credentials all day long.  But, when connected to my instance, I can't query the vendor instance.   I need to query and run jobs from my server, but can't.</p>
  
  <p>Here's some info on what I can and can't do:</p>
  
  <ul>
  <li><p>Login with their credentials and run queries: </p>
  
  <ul>
  <li>Server: Some.I.P.Address\SomeName</li>
  <li>U: ReadOnlyUser</li>
  <li>P: ThePassword</li>
  </ul></li>
  <li><p>I Created a linked server with my local logins and the above remote user which will pass a connection test.</p></li>
  <li><p>From my server I can query a remote system table, but not the remote user tables:</p>
  
  <ul>
  <li>Meaning I CAN NOT do this:</li>
  </ul>
  
  <p>Select top 1 * from [Some.I.P.Address\SomeName].DateBaseName.ReadOnlyUser.[TableName]</p>
  
  <ul>
  <li>But I CAN do this: </li>
  </ul>
  
  <p>SELECT top 1 * FROM [Some.I.P.Address\SomeName].master.sys.Servers</p></li>
  </ul>
  
  <p>How come I can connect directly to the remote instance and run queries, but when I am connected to my server I can only query the system tables?</p>
  
  <p>It gives me this error, but A) the table does exist, and B) the user does have permissions because I can connect directly with the same credentials that pass the linked server connection test and run a query on that table.:</p>
  
  <pre><code>Msg 7314, Level 16, State 1, Line 1
  The OLE DB provider "SQLNCLI11" for linked server "[Some.I.P.Address\SomeName]" does not contain the table ""DateBaseName"."ReadOnlyUser"."TableName"". The table either does not exist or the current user does not have permissions on that table.
  </code></pre>