We are trying to copy azure databases via powershell over multiple subscriptions. Currently using Start-AzureSqlDatabaseCopy and New-AzureRmSqlDatabaseCopy and since the principal only exists in one subscription, we’re getting ethere permissions or can’t find rg errors.
Can’t be the 1st person to do this, so looking for advice here please. Thanks in advance.
Hi,
Thanks for getting in touch. The Service Principal exists in the Azure AD tenant, and I’m pretty sure can be given permissions to any subscriptions related to that tenant. If you go to the Access Control (IAM) settings for the subscriptions you should be able to see/assign roles for the Service Principal within the subscription. Or are these subscriptions part of separate Azure AD tenants?
Regards
Shannon