title: Named pipes provider could not open connection to SQL Server 1231
body: <p>I am trying to set up a linked server and running into an issue. </p>
  
  <p>On the target server I have configured a user, let's say Q. I have set the source server to connect with Q's login credentials no matter what user is logged in at Source Server.</p>
  
  <p>However when I try to connect, I get the error</p>
  
  <blockquote>
    <p>"Named pipes provider : could not open a connection to SQL Server
    [1231]."</p>
  </blockquote>
  
  <p>I have tried enabling and disabling named pipes in the server configuration manager, to no avail. </p>
  
  <p>Also I have seen some things saying it is a security problem. The thing is, I am able to connect from Target to Source using Q's credentials in SQL management studio just fine. </p>
  
  <p>Is there something stupid I'm missing here? </p>