Cross tenant writes to sql

Saksham Chhabra 5 Microsoft Employee

How to write from a different tenant (say Mooncake, Fairfax) running app service (WebJob) to an Azure SQL in PME tenant without using sql conn string. Can SPN be used for the same, if yes where should the base registration lie

Vinodh247-1375 11,206 Reputation points

2024-04-19T06:10:54.0366667+00:00
Hi Saksham Chhabra,

Thanks for reaching out to Microsoft Q&A.

How to write from a different tenant (say Mooncake, Fairfax) running app service (WebJob) to an Azure SQL in PME tenant without using sql conn string. Can SPN be used for the same, if yes where should the base registration lie

yes, you can leverage the SPN when you want to write to a different tenant. Follow the below highlevel steps

Create Azure Key Vault:

Create SPN:

Retrieve Tokens Using AD Auth Lib: This token will allow your application to connect to Azure SQL.

https://www.mssqltips.com/sqlservertip/7914/secure-connections-to-azure-sql-using-service-principal-authentication/

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.
ShaktiSingh-MSFT 13,426 Reputation points Microsoft Employee

2024-04-22T03:45:34.7+00:00

Hi Saksham Chhabra,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks