title: Cannot connect to SQL Server, error: 0 - No Connection could be made because the target machine actively refused it
body: <p>I'm new to SQL related matters so please bare with my lack of knowledge and asking a question which has been asked countless times before. </p>
  
  <p>I have to connect to a SQL database server which is located at a remote location at xxx.xx.xxx.xx:3306, but every time I try to connect I get the same error:</p>
  
  <blockquote>
    <p>"A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)"</p>
  </blockquote>
  
  <p>I get this same error whether I try to connect using SQL Server Management Studio or in a C# program via:</p>
  
  <pre><code> SqlConnection myConnection = new SqlConnection(...)
   myConnection.Open();
  </code></pre>
  
  <p>I've tried it on two different computers, both on the same home network. I've had a look at the SQL server configuration manager on the computer which I installed SQL Server on, enabling TCP/IP and fiddling with the port values settings, but I'm guessing this is just for configuring an SQL server on my computer and irrelevant to connecting to a remote one. I shouldn't even need to install SQL server to do queries on a remote server anyway, right? </p>
  
  <p>I've turned off my Windows firewall and my router firewall, though <a href="https://www.grc.com/x/ne.dll?bh0bkyd2" rel="nofollow">ShieldsUP</a> still says </p>
  
  <blockquote>
    <p>Port: 3306 
    Status: Stealth    </p>
    
    <p>Your system has achieved a perfect "TruStealth" rating. Not a single packet — solicited or otherwise — was received from your system as a result of our security probing tests. Your system ignored and refused to reply to repeated Pings (ICMP Echo Requests). From the standpoint of the passing probes of any hacker, this machine does not exist on the Internet. Some questionable personal security systems expose their users by attempting to "counter-probe the prober", thus revealing themselves. But your system wisely remained silent in every way. Very nice.</p>
  </blockquote>
  
  <p>I read that this is irrelevant as well, since I'm not the one hosting the server, but when I was given the address, I was given the port as well, so I must have to do something with it. I'm just not sure what. My understanding of ports really is quite shaky.</p>
  
  <p>I've been trying this for over a day now, and I can't think of anything more I can do.</p>
  
  <p>EDIT: I fixed the problem. I had to use MySQL, not MSSQL. Doh. Sorry guys.</p>