Locate tenant and subscription of Azure database server

Anders 5 Reputation points
2023-11-26T21:28:28.4433333+00:00

I cannot find the tenant or subscription of a database that I am running.

I have consolidated multiple Azure subscriptions (including one all the way back from 2008!).

However, I have an application that uses an Azure database (with basic authentication), but I cannot find its database server in any of the subscriptions I have access to.

How do I locate the subscription that a database server belongs to?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,381 Reputation points Microsoft Employee
    2023-11-27T04:30:03.2+00:00

    Hi Anders •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you are unable to find Azure SQL Server as to which Subscription it belongs.

    Please try to open Azure Portal and if you know SQL Database/SQL Server Name, you could find details in the overview page like below:

    User's image

    Or you could try to list all SQL Servers present in the Resource Group using Azure CLI command as shown below:

    User's image

    Example: az sql server list --resource-group 'resourceGroupName'

    Please try and let us know if this helped.

    If not, please share more details so that we can help you.

    Thanks

    0 comments No comments