title: How to set a proper connection string for Azure database?
body: <p>I have an azure website and database. I'm running an ASP.NET MVC 4 / EF 5 app localy and trying to put some data to the azure database before to deploy the app. But I have a TargetInvocationException : {"The ASP.NET Simple Membership database could not be initialized. For more information, please see <a href="http://go.microsoft.com/fwlink/?LinkId=256588" rel="nofollow">http://go.microsoft.com/fwlink/?LinkId=256588</a>"}
  Keyword not supported : server</p>
  
  <p>This is the connection string that I get from my azure dashboard :</p>
  
  <pre><code>    &lt;add name="myconstring" connectionString=Server=tcp:myserver.database.windows.net,1433;Database=mydatabase;User ID=cdptest@myserver;Password=******;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>I tried this I got "Keyword not supported : data source"</p>
  
  <pre><code>    &lt;add name="myconstring" connectionString="Data Source=myserver.database.windows.net;Initilal Catalog=mydatabase;User ID=cdptest@myserver;Password=*****;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.EntityClient"/&gt;
  </code></pre>