title: SQL Server native client 11.0 does not support connection to SQL Server 2000 or earlier version
body: <p>I'm trying to get data from a SQL Server 2000 database and insert it into another database in SQL Server 2012.</p>
  
  <p>The linked server was created, but I get an error when I use <code>SELECT</code> from one of the tables.</p>
  
  <p>Something like this:</p>
  
  <pre><code>SELECT * 
  FROM linked_server_name.database_name.schema.table_name
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>SQL Server native client 11.6 does not support connection to SQL Server 2000 or earlier versions</p>
  </blockquote>
  
  <p>Any idea can be helpful. Thanks.</p>