title: How to fix dbcontext scaffold "Login failded for user {'username}"
body: <p>When I am trying to connect to my Azure SQL Database via Enitity Framework Core I always get the Error Message "Login failed for User {'Username'}", how can I fix this?</p>
  
  <p>I tried with this Code:</p>
  
  <pre><code>dotnet ef dbcontext scaffold "Server=tcp:XXX.database.windows.net,1433;Initial Catalog=Calculator;Persist Security Info=True;User ID={XXX};Password={XXX};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" Microsoft.EntityFrameworkCore.SqlServer -o Models
  </code></pre>
  
  <p>The Username and password are the credentials from the DB Owner, so I should have all the rights I need.</p>
  
  <p>And I recieve this Error Message:</p>
  
  <pre><code>Login failed for User {XXX}
  </code></pre>
  
  <p>At first I updated my Firewall rules and added my IP Adress.</p>
  
  <p>I have already tried to connect the project with a local DB, which worked fine.</p>
  
  <p>Furthermore I logged into the DB via SSMS which worked fine too.</p>
  
  <p>Did I forget to modify some Settings?</p>
  
  <p>For my Defense: Its the first time I am using Azure so please be kind if its a dumb error.</p>