Can't create a database in Azure

Hello,

Thanks for reaching out to Microsoft Q&A.

How are you, @RogerSchlueter-7899

Please try the following options with detailed steps:

1. Check Your Role Assignments

To create a database, your account must have the appropriate permissions—typically the Contributor role or higher.

Steps:

• Go to the Azure Portal.
• Navigate to the Resource Group or Subscription where you want to create the database.
• Click on Access Control (IAM) from the left-hand menu.
• Select View my access to see your current roles.
• If you do not see “Contributor” or a higher role (like Owner), contact your administrator to assign the correct role.

2. Clear Browser Cache

Authentication tokens can be cached and cause issues.

Steps:

• Open your browser settings.
• Go to Privacy & Security.
• Select Clear browsing data.
• Choose Cookies and other site data and Cached images and files.
• Click Clear data.

3. Try a Different Browser or Incognito Mode

This helps bypass cached sessions or extensions that may interfere.

Steps:

• Open a new Incognito/Private window in your browser.
• Navigate to Azure and sign in.
• Try creating the database again.

4. Check Azure Service Status

Azure services may be experiencing outages that affect token retrieval.

Steps:

• Visit https://status.azure.com
• Look for any alerts related to Azure Active Directory, SQL Database, or Token Services.
• If there’s an outage, wait until it’s resolved before retrying.

5. Sign Out and Sign Back In

Refreshing your session can help renew access tokens.

Steps:

• Click your profile icon in the top-right corner of the Azure portal.
• Select Sign out.
• Close the browser completely.
• Reopen the browser and sign in again at Azure.

6. Use Azure CLI or PowerShell

If the portal still doesn’t work, try using CLI or PowerShell.

Azure CLI References:

• https://learn.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?view=azuresql
• https://docs.azure.cn/en-us/azure-sql/database/scripts/create-and-configure-database-cli

PowerShell References:

• https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-powershell?view=azuresql
• https://github.com/Azure/azure-powershell/blob/main/src/Sql/Sql/help/New-AzSqlDatabase.md

If you have any further questions, feel free to respond in this same thread.

Hello @RogerSchlueter-7899,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Thanks a lot for the detailed help.

I cannot get beyond Step 3: Click on Access Control (IAM) from the left-hand menu

because I cannot find that menu option. I have attached an image of what I get when I go to Subscriptions. Can you identify what the problem is?

Hi RogerSchlueter-7899,

Based on the screenshot you provided, one of these situations may apply:

• No active subscription – A subscription may not have been created yet, or a previous trial might have expired or was never activated.
• Signed in to the wrong account or directory – You could be logged into a personal account or an Azure Active Directory (AAD) tenant that doesn’t contain your subscriptions.
• Access not assigned – Your organization’s administrator may not have granted you access to any subscription yet.

If you don’t Have a subscription you can try with below

• Personal account: Sign up for a Free Trial or Pay-As-You-Go subscription.
• Work/School account: Contact your Azure admin or IT team to get added to an existing subscription.

Recheck to fix It:

• Check your Azure Directory In the portal, confirm you’re in the correct AAD tenant. If you belong to multiple tenants, switch to the one with subscriptions.
• Verify your access Even if your role says “All,” you might not have permissions. Try selecting a specific role like Owner, Contributor, or Reader.
• Clear filters Remove all filters or adjust them to avoid hiding valid subscriptions.
• Check management group scope If subscriptions are under a management group, make sure you’re scoped correctly.
• Try a different browser or Incognito mode Cached sessions or extensions can cause issues.

If you have any further questions, feel free to respond in this same thread.

@Swapnesh Panchal I think you've identified the issue, namely, that I don't have an active subscription. However, when I go through the steps on the page where one gets one, I get, in a very large font:> Something went wrong. We are investigating.

I'll keep trying to get an active subscription and, once successful, I'll come back here if I run into further problems.