Locate tenant and subscription of Azure database server

Question

Locate tenant and subscription of Azure database server

Anders 5

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?

Anders 5 Reputation points

2023-11-27T10:04:31.8666667+00:00

Hi @SSingh-MSFT

Thank you for the answer.

I have signed in on my different directories and tenants, and list all resources. However, there is no database server on the list for any of them. So I must be missing one of the directories/tenants.

When I consolidated my Azure tenants, as mentioned in the original post, I have deleted some users and changed or removed domains. Maybe that has taken away the access. In any case, my problem is that I do not know which logon to use to get access to this database server.

PS: I have used Azure SQL database since it started in beta at the end of 2008, so I am quite experienced with how it works and how to find it.
SSingh-MSFT 16,461 Reputation points Moderator

2023-11-28T05:52:49.6666667+00:00

Hi Anders •,

Many Thanks for being an honored Azure user.

We are sorry about the experience you are currently having with the above scenario.

I would recommend you to please file a support ticket for deeper investigation of the different accounts etc and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

1 answer

Your answer

Anders 5 Reputation points

2023-11-27T10:04:31.8666667+00:00

Hi @SSingh-MSFT

Thank you for the answer.

I have signed in on my different directories and tenants, and list all resources. However, there is no database server on the list for any of them. So I must be missing one of the directories/tenants.

When I consolidated my Azure tenants, as mentioned in the original post, I have deleted some users and changed or removed domains. Maybe that has taken away the access. In any case, my problem is that I do not know which logon to use to get access to this database server.

PS: I have used Azure SQL database since it started in beta at the end of 2008, so I am quite experienced with how it works and how to find it.
SSingh-MSFT 16,461 Reputation points Moderator

2023-11-28T05:52:49.6666667+00:00

Hi Anders •,

Many Thanks for being an honored Azure user.

We are sorry about the experience you are currently having with the above scenario.

I would recommend you to please file a support ticket for deeper investigation of the different accounts etc and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

Answer 1

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

Share via

Locate tenant and subscription of Azure database server

1 answer

Your answer