Use SQL databases on Azure Stack Hub
Use the SQL resource provider to offer SQL databases on Azure Stack Hub. After you install the resource provider and connect it to one or more SQL Server instances, you and your users can create:
- SQL databases for cloud-native apps.
- SQL databases for web applications.
Limitations to consider before installing the SQL resource provider:
- Users can only create and manage individual databases. Database Server instance isn't accessible to end users. This may limit compatibility with on-premises database apps that need access to master, Temp DB, or to dynamically manage databases.
- Your Azure Stack Hub operator is responsible for deploying, updating, securing, configuring and maintaining the SQL database servers and hosts. The RP service doesn't provide any host and database server instance management functionality.
- Databases from different users in different subscriptions may be located on the same database server instance. The RP doesn't provide any mechanism for isolating databases on different hosts or database server instances.
- The RP doesn't provide any reporting on tenant usage of databases.
For traditional SQL Server workload on premises, SQL Server virtual machine on Azure Stack Hub is recommended.
SQL resource provider adapter architecture
The resource provider consists of the following components:
- The SQL resource provider adapter virtual machine (VM), which is a Windows Server VM that runs the provider services.
- The resource provider, which processes requests and accesses database resources.
- Servers that host SQL Server, which provide capacity for databases called hosting servers.
You must create at least one instance of SQL Server or provide access to external SQL Server instances.
Hosting servers that are installed on Azure Stack Hub integrated systems must be created from a tenant subscription. They can't be created from the default provider subscription. They must be created from the user portal or by using PowerShell with the appropriate sign-in. All hosting servers are billable VMs and must have licenses. The service admin can be the owner of the tenant subscription.