title: Cannot connect Azure Web apps to Azure Database
body: <p>i have deploy an Azure website and Azure database for it. my website is a MVC website with Account Controller that need username and password to get in using asp .net. i've made the account for login. everything is okay until i login. my Azure apps throw exception that i assume that my web apps cannot connect to my Azure Database. </p>
  
  <p><a href="https://i.stack.imgur.com/mRqxB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mRqxB.png" alt="Login Error"></a></p>
  
  <p>so i deploy it again in my local machine with local database to check whether my apps is working or not .</p>
  
  <p>here is the list the thing that i've done and the result of login page :</p>
  
  <ul>
  <li>use local machine to local database (Success)</li>
  <li>use local machine to azure database (Success)</li>
  <li>use Azure website to Azure Database (fail)</li>
  </ul>
  
  <p>i've point my web apps to azure database in Azure Management Portal like like this
  <a href="https://i.stack.imgur.com/FyjXh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FyjXh.png" alt="My Data Connection in Azure"></a></p>
  
  <p>and also the connection string in Web.config file like this</p>
  
  <pre><code>&lt;add key="CMMSConnectionString" value="Data Source=tcp:(my azure database server).database.windows.net,1433;User ID=(my username);Password=(my password);Initial Catalog=(my azure database);" /&gt;
  </code></pre>
  
  <p>this exact same connection string worked from my local website.</p>
  
  <p>Any suggestions would be very welcome.
  NOTE : CMMS is the name of my project</p>