title: The linked server has been created but failed a connection test
body: <p>This is the first time I add Linked Server in SQL Server 2008. The remote server is SQL Server 2005.</p>
  
  <p>Now I specified the following,</p>
  
  <p><a href="https://i.stack.imgur.com/i7V8A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i7V8A.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/slPbU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/slPbU.png" alt="enter image description here"></a></p>
  
  <p>But I'm receiving the below error</p>
  
  <pre><code>SQL Server Network Interfaces: Connection string is not valid [87].  (Microsoft SQL Server, Error: 87)
  </code></pre>