SQL DB missing from portal

Hi,

I'm assuming you are Global Administrator in your Entra ID tenant. If my assumption is correct, please follow instructions in article below to elevate access:

Elevate access for a Global Administrator

https://learn.microsoft.com/en-us/azure/role-based-access-control/elevate-access-global-admin?tabs=azure-portal%2Centra-audit-logs#perform-steps-at-root-scope

Once your user has elevated access, sign out and sign-in again for the change to take effect.

Next navigate to subscription in Azure portal, then on left click Access control (IAM) blade.

Click Add -- Add role assignment, next click Privileged administrator roles tab, select Owner, click Next, click Select members, search for and Select your account, click Next, on Conditions tab select Allow user to assign all roles (highly privileged), click Review + assign, Review + assign.

Sign out and back in again for above change to take effect, and then check to see if Azure SQL Database and logical server shows up.

NOTE: It is possible there is another subscription that contains your SQL Database, so check for that and assign yourself Owner role on it, sign out/in, etc.

After you are finished please remember to toggle the elevated access back to off.

Please reply back here with your results, whether positive or negative.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Hi Spectra,

Greetings!

In addition to the response provided by @TP, I would like to add the following information.

As we understand that, you are facing an issue where your SQL Database seems to have vanished from the Azure Portal, even though your application is still working and you are still getting billed.

Here are some insights and potential steps to resolve the problem:

• Check Directory and Subscription: Make sure you are logged into the correct Azure directory and subscription where the SQL Database was created. Sometimes, users may switch accounts or subscriptions, which can cause resources to not appear.
• Verify Permissions: Confirm that your account has the necessary permissions to view the SQL Database resources. If your permissions have changed, you might not be able to see certain resources. You should have at least Contributor or SQL Database Contributor roles to manage databases.
• Use the Search Function: In the Azure Portal, try using the search bar at the top to search for your SQL Database by name. If it doesn’t show up, it may still be listed under a different resource group than you expect.
• Check for Filters: Sometimes, the portal dashboard can have filters set that hide certain resources. Make sure there are no active filters on your Azure SQL resource listings.
• Access via Azure CLI or PowerShell: If the portal isn’t being cooperative, you can also check for your SQL Database using Azure CLI or PowerShell. This might give you another viewpoint on whether the database exists.

If none of these step's help, could you please provide the requested details via private message as it will help us conduct a more thorough investigation?

I hope this information helps. Please do let us know if you have any further queries.

Hi TP,

Thanks for your reply. Although the issue is not resolved, it is very helpful as we're now pretty sure there is some issue around the account setup. As mentioned, we rarely use Azure and we just have this one DB (which wasn't in the default directory). I've never logged into or via Entra before. Once logged in (using my standard MS credentials) I can see I'm labelled as "Global Admin". The only Subscriptions showing though are for billing. When trying to add a subscription, there's only myself to select and I already have full access (of the 3 levels selectable - all of which seem to be focused around billing).

I don't suppose you have any other pointers that may help us uncover the DB?

You appear to be describing access to Cost Management + Billing or Cost Management, which is important, and you should have Owner role there, but I'm referring to Subscription.

Please navigate to list of subscriptions in portal using below link (I'm assuming your account is still elevated as I described above):

https://portal.azure.com/#view/Microsoft_Azure_Billing/SubscriptionsBladeV2

Click on your subscription. If you have multiple, repeat below steps for each one.

On left, click on Access control (IAM).

Click on View my access button

On right, does it show you as having Owner role assignment?

Hi TP

There are no subscriptions listed, this is the problem that we have (I may not have explained it properly previously).

I am a global administrator.