I would like to connect to an Azure SQL Database using my Azure Data Factory. The Azure SQL Database is created on another tenant and has SQL authentication disabled.
Is there another option to connect to this Azure SQL Database than using a Service Principal?
I tried to connect using User Managed Instance and System Managed Instance, but this does not seem to work as the Azure SQL Database is on another tenant. SQL Authentication is also not an option.
In case if the Azure SQL Database is in another tenant than ADF, then SQL Auth and Service principal auth are the only ways for the connectivity . Managed identities are only leveraged for same tenant components.