You deploy the above ARM template resource for a web app. The web app reads the connection string from the 'DefaultConnection' name. However, the web app fails to connect to the database with an error 'Login failed for user 'myuser'. What is the most likely cause?
If the server only allows Microsoft Entra authentication, SQL authentication will fail.
Why this answer
Option D is correct. The connection string includes a password in plain text. The recommended approach is to use managed identity and not include a password.
The login failure could be due to the password being incorrect or the SQL server not allowing SQL authentication. However, the most likely cause based on best practices is that the SQL server is configured to use Microsoft Entra authentication only, and the connection string uses SQL authentication. Option A is wrong because the type is correct for SQL Azure.
Option B is wrong because the connection string syntax is correct. Option C is wrong because the user ID should match the database user.