Edit

Share via

Enable SQL database in Fabric using Admin Portal tenant settings

  • Article

Applies to: ✅ SQL database in Microsoft Fabric

To enable this feature for your organization, use the SQL database admin switch.

Important

This feature is in preview.

You can enable SQL database for:

  • Your tenant - Use this option to enable SQL database for everyone in the tenant.
  • A specific capacity - Use this option if you want to enable SQL database for users in a specific capacity.

In both cases, you can use security groups to provide access to a specified list of users.

Prerequisites

Enable SQL database for your tenant

In your tenant, you can enable SQL database for:

The entire organization - In most cases your organization has one tenant, so selecting this option enables SQL database for the entire organization. In organizations that have several tenants, if you want to enable SQL database for the entire organization, you need to enable it in each tenant.

Specific security groups - Use this option to enable SQL database for specific users. You can either specify the security groups that SQL database will be enabled for, or the security groups that SQL database won't be available for.

Follow these steps to enable SQL database for your tenant.

  1. Navigate to the tenant settings in the admin portal and in Microsoft Fabric, expand Users can create Fabric items and SQL database (preview).

  2. Enable the Users can create Fabric items and SQL database (preview) switches.

  3. (Optional) Use the Specific security groups option to enable SQL database for specific users.

    • You can select The entire organization if you want everyone to create databases.
    • You can select Specific security groups to allow selected individuals in a group to create databases.
    • You can select Except specific security groups to block the access to create databases for individuals in that group. This option takes precedence over the previous one, if a user belongs to an included group and an excluded group, the individual would be blocked from creating databases.
    • Select Capacity admins can enable/disable if you want capacity admins to manage the control of who can access the SQL database workload.

  4. Select Apply.

Enable SQL database for a capacity

Capacity admins can override this setting, depending on their needs. For example, your organization might decide not to enable SQL database experience for everyone at tenant level but allow the usage of SQL database in a specific capacity. This lets your organization allow a group of developers try out SQL database in a specific capacity in a more controlled manner.

Follow these steps to enable SQL database in Microsoft Fabric for a specific capacity:

  1. Navigate to the capacity settings in the admin portal.
  2. Select the capacity where you want to enable SQL database.
  3. Select the Delegate tenant settings tab.
  4. Expand the SQL database (preview) setting.
  5. Check the Override tenant admin selection checkbox and verify that the SQL database (preview) setting is enabled.
  6. (Optional) Use the Specific security groups option to enable SQL database for specific users.
    • Select All the users in capacity if you want everyone to be able to create databases.
    • Select Specific security groups to allow selected individuals in a group to create databases.
    • You can also select Except specific security groups to block from creating the databases. This option takes precedence over the previous one, if a user belongs to an included group and an excluded group, the individual would be blocked from creating databases.
  7. Select Apply.

Disable SQL database

To disable SQL database, you can disable the SQL database (preview) admin switch.

If you disable SQL database for a specific capacity while it's available in your organization, your selection will only affect that capacity.

When SQL database not enabled in tenant settings, users who try to create a new SQL database will receive the error message "SQL database failed to create." The tenant admin switch is ignored for trial capacities. To disable and disallow SQL database in Microsoft Fabric, also disable trial capacities in your tenant by turning off the "Users can try Microsoft Fabric paid features" from the Fabric Admin portal.

Considerations

In some cases, users that don't have permissions to create databases will still be able to view SQL database items and icons.

Users that don't have SQL database enabled, can:

  • View SQL databases created by other users in the same workspace, as long as they have at least read-only access to that workspace.
  • View SQL database icons in capacities where SQL database has been enabled by an Admin, as long as they have at least read-only access to that capacity.

Next step

Create a SQL database in the Fabric portal

Related content