CODEWITHSUNDEEP
azureazure-sql-databaseazure-active-directory
Liero
Liero

Reputation: 27338

How to export Azure Database using Active Directory authentication and guest account

I have Azure Subscription with Default Directory with my company's account ([email protected]) as a guest.

I login to azure portal with this my company's account.

In the SQL Server, I have set Active Directory admin to an AAD group and I'm member of the group.

When I click Export (database) in Azure Portal, I select Active Directory authentication and type my username/password:

export database screenshot

However I'm getting:

Failed to export the database: MyDatabase. ErrorCode: 400 ErrorMessage: There was an error that occurred during this operation : 'Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unable to authenticate request; Inner exception System.Data.SqlClient.SqlException:Failed to authenticate the user [email protected] in Active Directory (Authentication=ActiveDirectoryPassword).; Error code 0xCAA20003; state 10; MSIS7068: Access denied.; '

Upvotes: 0

Views: 1974

Answers (1)

Tom Sun
Tom Sun

Reputation: 24529

Failed to authenticate the user [email protected] in Active Directory (Authentication=ActiveDirectoryPassword).; Error code 0xCAA20003; state 10; MSIS7068: Access denied

According to the error information that it indicates that the user password is not correct.

Based on my test, it works correctly if you set the Active Directory admin to an AAD group and if you are a member of the group.

enter image description here

Upvotes: 0

Related Questions