Share via

Unable to connect with SQL database using Entra ID.

Aaron 0 Reputation points
2024-10-30T06:45:44.78+00:00

I Joined my device with azure AD(Microsoft Entra ID) and log in with Azure AD user. then I trying to connect with SQL server(SSMS) but I'm unable to connect it ,But when try to connect with Local user it is connecting with windows auth. could you please suggest on this.

Microsoft Security | Microsoft Entra | Microsoft Entra ID
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Abiola Akinbade 30,490 Reputation points Volunteer Moderator
    2024-10-30T07:31:26.83+00:00

    Hello Aaron,

    Thanks for your question.

    It sounds like the issue may be related to permissions or configuration settings.

    To connect to Azure DB using SSMS follow the steps here:

    https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-ssms?view=azuresql

    If the steps there do not work or there are any specific issues please provide error logs

    You can mark it 'Accept Answer' and 'Upvote' if this helped you

    Regards,

    Abiola

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.