title: Having trouble adding a linked SQL server
body: <p>I'm trying to pull in data from a remote SQL Server. I can access the remote server using SQL authentication; I haven't had any luck using the same credentials with sp_addlinkedserver.</p>
  
  <p>I'm trying something like this:</p>
  
  <pre><code>Exec sp_dropserver 'Remote', 'droplogins'
  go
  
  EXEC sp_addlinkedserver   
     @server='Remote', 
     @srvproduct='',
     @provider='SQLNCLI', 
     @datasrc='0.0.0.0'
  
  EXEC sp_addlinkedsrvlogin
      @useself='FALSE',
      @rmtsrvname='Remote',
      @rmtuser='User',
      @rmtpassword='Secret'
  
  Select Top 10 * from Remote.DatabaseName.dbo.TableName
  </code></pre>
  
  <p>Here's what I get:</p>
  
  <pre>
  
  OLE DB provider "SQLNCLI" for linked server "Remote" returned message 
  "Login timeout expired".
  
  OLE DB provider "SQLNCLI" for linked server "Remote" returned message 
  "An error has occurred while establishing a connection to the server. 
  When connecting to SQL Server 2005, this failure may be caused by the 
  fact that under the default settings SQL Server does not allow remote 
  connections.".
  
  Msg 53, Level 16, State 1, Line 0
  Named Pipes Provider: Could not open a connection to SQL Server [53]. 
  </pre>
  
  <p>Again, I can access the server directly (in SQL Management Studio) using these exact credentials, so it's not a problem with my network or credentials.</p>
  
  <p>Most of the examples I've seen online seem to involve Windows domain accounts, as opposed to SQL security logins. Does this not work with SQL authentication?</p>