title: How to create linked server from SQL Server 2014 to SQL Server 2012
body: <p>I have two machines one is running SQL Server 2014 (Machine A) and the other one SQL Server 2012 (Machine B). Machine A has storage limitation and hence I decided to leave all databases on the Machine B so I can connect and use data from Machine A.</p>
  
  <p>I set Machine B so I can connect it remotely. Now, I am able to connect from Machine A to Machine B. My problem is that, I am unable to push my data from Machine A to B. I guess I need Linked-Server. I tried to build Linked server but when I make linked server, it gives me below error:</p>
  
  <blockquote>
    <p>Named Pipes Provider: Could not open a connection to SQL Server [5]. 
    OLE DB provider "SQLNCLI11" for linked server "192.168.0.18/SQLEXPRESS" returned message "Login timeout expired".<br>
    OLE DB provider "SQLNCLI11" for linked server "192.168.0.18/SQLEXPRESS" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 5)</p>
  </blockquote>
  
  <ul>
  <li><p>Linked server name is : <code>192.168.0.18/sqlexpress</code> and I set to use my user name and password. </p></li>
  <li><p>Machine A: Mac running Microsoft Windows on Parallel (I connect using Win 8.1 that runs over Mac Yosemite).</p></li>
  <li><p>Machine B: Windows 8.1 on physical server (no VM).</p></li>
  </ul>
  
  <p>I have enabled <strong>Named Pipe</strong> from network configuration of my Machine B SQL server. However, I think I need to do some modification on port number with my Firewall.</p>
  
  <p><strong>UPDATE:</strong> I disabled Firewall on Machine B, but no clue yet.</p>
  
  <p>Please advise.
  Thanks </p>