CODEWITHSUNDEEP
azureazure-sql-databaseazure-active-directory
Gvazzana
Gvazzana

Reputation: 603

Logging into Azure Sql

I created a user in our AD Connected on-prem Active Directory. The user is synced up to AAD.

This user is now tied to our on-prem domain

I have added this user as the SQL Active Directory Admin

My issue is:

I cannot login to azure sql with this AD Admin via SSMS or sqlcmd

I receive the error, login failed, as if the password isn’t correct or something

My question is: Can I login to Azure sql with an on-prem ad synced aad user account?

Does Azure sql tie to the AAD tenant domain only, regardless of we have an AD-Connect set up with our on-prem domain?

I need to login to sql with the ad admin account, to beable to add other aad users or groups as a sql dB user

I believe that creating the user in our Ad makes the azure sql not recognize it, since the azure sql is on the aad domain

Is this possible?

Upvotes: 1

Views: 301

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15684

Use this Azure documentation to configure Azure Active Directory (AAD) and use it to access an Azure SQL Database. After configuring AAD, you just need to add an ADD group as Azure SQL Database admin and all user part of that group will be able to use MFA authentication. You can use SQL Server Management Studio to test it.

SQLCMD does not support MFA authentication.

Upvotes: 1

Related Questions