title: ArgumentException: Keyword not supported: 'server'
body: <p>I have an Asp.net MVC5 application and have published it to <code>Microsoft Azure</code>. I first migrated my <code>.mdf</code> files to<code>Sql Azure Databases</code>. The database connection string provided in the <code>Azure Portal</code> is not working.</p>
  
  <blockquote>
    <p>[ArgumentException: Keyword not supported: &#39;server&#39;.]</p>
  </blockquote>
  
  <p>My connection string is as follows <code>web.config</code></p>
  
  <pre><code>connectionString="
      Server=tcp:dbprojectserver.database.windows.net,1433;
      Initial Catalog=db_project;
      Persist Security Info=False;
      User ID=username@servername;
      Password=kenth&amp;amp;&amp;amp;123;
      Encrypt=True;
      TrustServerCertificate=False;
      Connection Timeout=30;
      "
  </code></pre>
  
  <p>I believe so there is something wrong with this connection string. Any help regarding that is highly appreciated.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Reading from here <a href="https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx" rel="nofollow noreferrer">SQL Server Connection Strings</a> and following EF Db first or Model first connection string example</p>
  
  <pre><code>&lt;add name="ConnectionStringName"
      providerName="System.Data.EntityClient"
      connectionString="metadata=res://*/ ContextClass.csdl|res://*/ ContextClass.ssdl|res://*/ ContextClass.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=ServerName;Integrated Security=False;User Id=userid;Password=password;MultipleActiveResultSets=True&amp;quot;" /&gt;
  </code></pre>
  
  <p>This is what I am using according to above example</p>
  
  <pre><code>&lt;add name="ProjectEntities" connectionString="metadata=res://*/ ProjectWeb.Models.User.csdl|res://*/ ProjectWeb.Models.User.ssdl|res://*/ ProjectWeb.Models.User.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=tcp:dbprojectserver.database.windows.net,1433;Integrated Security=False;User Id=username@servername;Password=kenth$$123;MultipleActiveResultSets=True&amp;quot;
        " providerName="System.Data.EntityClient"/&gt;
  </code></pre>
  
  <p>It says </p>
  
  <blockquote>
    <p>Keyword not supported 'data source'</p>
  </blockquote>