Need help with subscirption in azure sql

Question

Going thru trying to create an Azure SQL server to run some stuff in our Azure account. When we try and ad this to our pay as you go account, it says you can not add this service? How do I add this permission for a free SQL server account?

Answer 1

Answer 2

@Mark Jozwiak

You only get a "free trial" of SQL with a free Azure subscription for 12 months, and it is a basic instance with minimal DTUs. If you've already converted to Pay-As-You-Go, or are past the time limit, you can only create non-free instances. You could possibly create another free Azure subscription by using a different account, and a valid payment method.

Try Azure SQL Database free with Azure free account

You must also have rights within the subscription to create the instance, such as "Owner" or "Contributor" level permissions,

Assign a user as an administrator of an Azure subscription

Please upvote or accept this thread as answered if it's helpful, thanks!

Answer 3

Hi @Mark Jozwiak ,

the error message points to missing permissions to create a new Resource Group in the subscription.
Please verify the role based permissions of the account you are using to create the Resource Group in the Azure Subscription.
The built-in role Contributor or Owner for instance provides the permission to create new Resource Groups in an Azure Subscription.
More details you will find here: https://learn.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

What happens if you select an existing Resource Group in the Azure Subscription to create a VM?

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 4

Ok it seems to move on. I was able to select an existing resource, I just don't know anything about that resource. Let me see what happens.

Thanks!