How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '

Question

Hi All,
I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but while the token is successfully generated, I am getting the following error during authentication:

Error encountered:
*"Microsoft.Data.SqlClient.SqlException: 'Login failed for user '

Answer 1

@NIKHILA NETHIKUNTA , Since I am using dotnet framework 4.8, the solution was to specify the authentication as Active Directory Default within the connection string and also remove the unwanted below code as its taken care internally.

var credential = new DefaultAzureCredential();

var tokenRequestContext = new TokenRequestContext(new[] { "https://database.windows.net/.default" });

var token = credential.GetToken(tokenRequestContext);

connection.AccessToken = token.Token;

Answer 2

@NIKHILA NETHIKUNTA Since I am using dotnet framework 4.8, the solution was to specify the authentication as Active Directory Default within the connection string and also remove the unwanted below code as its taken care internally.

var credential = new DefaultAzureCredential();

var tokenRequestContext = new TokenRequestContext(new[] { "https://database.windows.net/.default" });

var token = credential.GetToken(tokenRequestContext);

connection.AccessToken = token.Token;