Forum Discussion
Cross database queries- Authentication with managed identities
Hi All; I've recently has a situation where I need to query data across 2 databases in Azure; Now both these Db's are on the same logical server with database A being auditing data from several ...
I have not tested your exactly scenario - external table from sql to sql, but Azure SQL supports managed identities to access blob storage, for example. There is a special way to set the managed identity and create the credential, but it works.
Have you tried something similar? Here is a reference I wrote: https://www.red-gate.com/simple-talk/blogs/azure-sql-and-managed-identity/
Kind Regards,
Dennes
Have you tried something similar? Here is a reference I wrote: https://www.red-gate.com/simple-talk/blogs/azure-sql-and-managed-identity/
Kind Regards,
Dennes