Forum Discussion
Azure sql database - find out which tenant is belongs to
Hi
No to search for a database or a server you need to connect to specify a subscription .
If there is no active subscription you cannot search or find anything . Tenant is only for Active directory not for Azure resources . Therefore you cannot host a database in a tenant.
Also xyzsql.database.windows.net is a server not a database .
If you can reactivate inactive subscriptions or search for an active one may be you can query for each Azure resource graph and find the server and its database .
From the portal go to :
https://portal.azure.com/#blade/HubsExtension/ArgQueryBlade
In the query section enter :
Example in screenshots
- ArjanAnthonisseJun 24, 2021Copper Contributor
ibnmbodji The problem is not that we cannot connect to the database. The problem is that we don't know to which subscription it belongs, so we cannot contact the administrator of the subscription.
So, I would like to know it the subscription id is somewhere in the database. That way, we cna contact Microsoft to ask who pays for the subscription.