title: Connection failed: SQLState: '01000' SQL Server Error: 10061
body: <p>I'm trying to connect my access front-end to the SQL Server backend.</p>
  
  <p>It was working when SQL Server was on my computer but now i'm trying to connect to a server</p>
  
  <p>So when I create the DSN file with access</p>
  
  <ol>
  <li>I chose SQL-Server driver ( I have also tried with SQL-Server native 10.0 )</li>
  <li>I enter the server name that I copied from SQL Management Studio so there's no typo there</li>
  <li>I chose the NT authentication</li>
  </ol>
  
  <p>Then I have this error</p>
  
  <p><img src="https://i.stack.imgur.com/IooiM.png" alt="enter image description here"></p>
  
  <p>In the properties, I tried with <code>TCP/IP</code> with the default port 1433 and I also tried with the name pipes </p>
  
  <p>I made sure that the checkbox to allow remote connection is checked</p>
  
  <p>If I try to connect with management studio I got this error</p>
  
  <p><img src="https://i.stack.imgur.com/IfiaA.png" alt="enter image description here"></p>
  
  <p>I can see the server when I browse on the network</p>
  
  <p>I'm trying <a href="http://blogs.msdn.com/b/sql_protocols/archive/2007/07/19/tcp-provider-no-connection-could-be-made-because-the-target-machine-actively-refused-it.aspx" rel="noreferrer">this</a> troubleshotting but i'm stuck with the telnet command. It says <code>Could not open connection to host on 1433</code> </p>
  
  <p>I also tried with no port and i got the same error on port 23</p>
  
  <p>Any ideas?</p>
  
  <p>Thank you</p>