Hi @ Merin Mary
Thanks for the Question and using Microsoft Q&A platform
As per my understanding, you need to access SQL database in Tenant B's subscription from the subscription in Tenant A.
To access SQL database in Tenant B subscription, you need to create a Private Endpoint for the SQL database in Tenant B's subscription. This endpoint will give the database a private IP address within Tenant B's Virtual Network (VNet).
The VNets in Tenant A and Tenant B must be peered. This is necessary for secure communication between both VNets. You will need to establish VNet peering to allow Tenant A to access the database through the private endpoint.
Please go through these documentations that might help you:
https://learn.microsoft.com/en-us/azure/virtual-network/virtual-network-peering-overview
Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.