Azure Managed SQL Instance Windows Authentication

[harbinger]

Hi

We've recently introduced the first Azure Managed SQL Instance to our environment and want to use Veeam Backup for Azure to backup the databases on this instance.
Since february there is the new Windows authentication metadata mode available on the managed instance to be able to use for legacy apps which still require these authentication settings (https://docs.azure.cn/en-us/azure-sql/m ... principals). If we configure these users directly on the database, the backup fails with the error:

Code: Select all

Error SQL71627: The element User: [domain\username] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
Error SQL71627: The element Login: [domain\username] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.

As far as I can see the native backup of the Managed Instance is working even when these users are added and this method is also using the bacpac method as far as I know.
Is there maybe a new Auzre API available which has to be still implemented in VBA to be able to backup databases with these kinds of logins?

BR
Philipp

[Vitaliy S.]

Hi Philipp,

I will pass this feedback to the RnD team for consideration in future releases.

Thanks for sharing this information!