How can I make my DB connection works?
<p>I set up a MySQL database in my AZURE account, but I cannot connect it in any way. I tried:</p>
<pre class="lang-cs prettyprint-override"><code>namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection sqlconnection = new SqlConnection(&quot;Database=Banco1; Data Source=br-cdbr-azure-south-a.cloudapp.net;User Id=USERID Password=PASSWORDid&quot;);
            Console.WriteLine(&quot;1&quot;);
            sqlconnection.Open();
            Console.WriteLine(&quot;2&quot;);
            SqlCommand cmd = new SqlCommand(&quot;CREATE TABLE Customer(First_Name char(50), Last_Name char(50), Address char(50), City char(50), Country char(25), Birth_Date datetime); &quot;, sqlconnection);
            Console.WriteLine(&quot;3&quot;);
            cmd.ExecuteNonQuery();
            Console.WriteLine(&quot;4&quot;);
            Console.ReadLine();
        }
    }
}
</code></pre>
<p>I tried putting prints through the commands, and the program only prints &quot;1&quot; wich means I can't get the connection opened... how can I fix that?</p>
<p>The output error:</p>
<blockquote>
<p>An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll</p>
<p>Additional information: Error in the network or specifics to the instance when stablishing conexion to the SQL Server. The server was not found or was not avaible. Check if the instance name is correct and if the SQL Server is configured to allow remote conexions. (provider: Named Pipes Provider, error: 40 - Could not stablish connection to SQL Server)</p>
</blockquote>