Import / Export database from Azure SQL Server using AD authentication

0
votes

I'm getting an error when attempting to either export or import SQL Server databases through the Azure Portal using an user account that is in the SQL Server AD administrators group.

As you can see I have an AD group attached to the SQL Server and I am a member in that group.

enter image description here

When I attempt to export or import a database from that server using my user credentials (and selecting Active Directory in the Authentication Type), I get the following error:

Failed to export the database: TheNameOfTheDatabase.
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; '

1
sql-serverazureazure-active-directoryazure-sql-database

1 Answers

0
votes

Sometimes services Azure portal does not work as expected temporarily. As a workaround, try to export the database using the latest version of SQL Server Management Studio and the feature named “Export a Data-Tier Application”.

Try also using SqlPackage utility.

SqlPackage.exe /a:Export /tf:testExport.bacpac /scs:"Data Source=apptestserver.database.windows.net;Initial Catalog=MyDB;" /ua:True /tid:"apptest.onmicrosoft.com"

Make sure “Allow Access to Azure services” is ON on the firewall rules.