title: Azure error - connection string difficulties
body: <p>I am working with an mvc5 application in vs 2015.
  I am getting errors whenever I attempt to access items from the database</p>
  
  <blockquote>
    <p>Login failed for user '{your_username}'.</p>
  </blockquote>
  
  <p>When I go azure portal "allow access to azure services" setting is on with my client Ip address listed.
  I think my connection string is not configured correctly. I can't figure out how to correctly configure it on my local machine and with azure.  </p>
  
  <p>I have kept my  the connection string in my web config to my  local server which worked previously:</p>
  
  <p><strong>In my web.config</strong> </p>
  
  <pre><code>&lt;add name="IdentityDbContext" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=C:\Users\UserName\EduSmart_db.Mdf;          Initial Catalog=EduSmart_db;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>In Azure Portal connection string</p>
  
  <pre><code>Server=tcp:xxxx.database.windows.net,1433;Initial Catalog=Edu;Persist Security Info=False;User ID=Name;Password=Password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
  </code></pre>
  
  <ul>
  <li>How can I tell which connection string azure is using?</li>
  <li>Is there  a different problem i have not considered?</li>
  </ul>