title: User login failed for <user> in production but same connection string works from local client
body: <p>I have an Azure database setup of which I have included the below connection string as I believe it should be. Problem is when I try to run my client app in production, the server returns a 500 internal error. After investigating it through remote debugging I find that it's saying</p>
  <pre><code>&quot;Login failed for user &quot;&lt;my user_id&gt;&quot;
  </code></pre>
  <p>My Appsettings.json
  <a href="https://i.stack.imgur.com/kokzF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kokzF.png" alt="enter image description here" /></a></p>
  <p>My connection string provided during runtime when deploying my api
  <a href="https://i.stack.imgur.com/y25CQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y25CQ.png" alt="enter image description here" /></a></p>
  <p>Don't worry about the blacked-out portions... I've verified those to be the same in both.</p>
  <p>Now when running everything locally, calling the exact same database with that very connection string everything works as it should; I can add records to that production Azure database just fine, but as soon as I try doing the same from my client app from production I get that dreaded error mentioned above.</p>
  <p>Can anyone tell me what might be happening? I've been over and over this and it's driving me mad. I've even gone as far as changing the connection string to be Server=... I've made sure to append the @ to the user_id. I believe I've tried just about everything I could find that wasn't 8 years old, including searching similar issues here... nothing seems to be quite like my issue exactly.</p>
  <p>If you need more information let me know and I'll update my question.</p>
  <p>Thanks!</p>
  <p>EDIT: Adding this to show I've already added all of my output IPs from my api app service to my Sql server firewall. Can someone tell me if all my settings look good?</p>
  <p><a href="https://i.stack.imgur.com/VRB77.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VRB77.png" alt="enter image description here" /></a></p>