Backups to BLOBs from SQL MIs using Managed Identity credentials

[alinselicean]

Hello

We are using your tool to create a COPY_ONLY backup for our databases running on a number of SQL Managed Instances. However, due to some security requirements, we are not allowed to use SAS tokens, but instead use Managed Identity to control the access to URL blobs.

The DatabaseBackup SP is only checking for SAS credentials. I changed the code now to also include credentials using Managed Identity on my instances, but probably the best thing would be to just look if a credential with the required name exists.

[FSalot]

Hello,
I'm facing the same issue with SQL Credential.

• It works in SSMS without using @credential parameter
• It doesn't works when I'm using a powershell script even if I use @credential parameter. I always have the error "The value for the parameter @credential is not supported."

Do you have any solution for this issue?
have a nice day,
Florent

[FSalot]

Hello,
I'm not sure, you still have the issue...
We solved the issue by adding sysadmin right to the backup user.

Without this right, the backup user seems to not be able to found the credential registred in SQL Instance.

Have a nice day,
Florent