title: Login failed for user 'san' in SQL Server on Azure
body: <p>I keep getting an error </p>
  
  <blockquote>
    <p>Login failed for user 'san' </p>
  </blockquote>
  
  <p>while using Azure database from Web API with Entity Framework.</p>
  
  <p>Here is the screen shot of SSMS. I am able to access the database from SSMS, but not from the Web API database call.</p>
  
  <p><a href="https://i.stack.imgur.com/6HjjR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6HjjR.png" alt="image of ssms"></a></p>
  
  <p>I tried to create a new login and user but getting an error </p>
  
  <blockquote>
    <p>User already exists</p>
  </blockquote>
  
  <p>The same problem has been ask in the below link but those solution did not work for me</p>
  
  <p><a href="https://dba.stackexchange.com/questions/141239/login-failed-for-user-on-sql-azure-from-azure-hosted-web-application">https://dba.stackexchange.com/questions/141239/login-failed-for-user-on-sql-azure-from-azure-hosted-web-application</a></p>
  
  <p><a href="https://stackoverflow.com/questions/39035464/azure-sql-login-failed-for-user">Azure SQL - Login failed for user</a></p>
  
  <p><a href="https://dba.stackexchange.com/questions/102605/azure-sql-database-login-failed-for-user-in-application-but-works-fine-in-ssm">https://dba.stackexchange.com/questions/102605/azure-sql-database-login-failed-for-user-in-application-but-works-fine-in-ssm</a></p>
  
  <p>Here is the connection string </p>
  
  <pre><code>"DefaultConnection": "Server=tcp:fetessbird.datatable.windows.net,1433;Initial Catalog=Falcon;Persist Security Info=True;User ID=san;Password=*****;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
  </code></pre>
  
  <p>I am able to access the database from SSMS not from the webapi</p>