Edit

Remove the SQL resource provider

Important

The SQL and MySQL resource providers for Azure Stack Hub are deprecated and aren't available for onboarding new customers. Instead, deploy SQL or MySQL directly on virtual machines and manage them by using standard tools and practices. Existing deployments of the resource providers continue to be supported, but no new feature development or onboarding is planned.

When you remove the SQL resource provider, you delete:

  • The SQL resource provider.
  • The associated plans and quotas that the operator manages.
  • The metadata in Azure Stack Hub for the hosting server, database, and logins.

When you remove the SQL resource provider, you don't delete:

  • The tenant databases on the hosting servers.
  • The packages used to install SQL RP.

To remove the SQL resource provider V1

  1. Verify that you removed all the existing SQL resource provider dependencies.

    Note

    The uninstallation process continues even if dependent resources currently use the resource provider.

  2. Get a copy of the SQL resource provider installation package, and then run the self-extractor to extract the contents to a temporary directory. To find the download links for the resource provider installers, see Deploy the resource provider prerequisites.

  3. Open a new elevated PowerShell console window and change to the directory where you extracted the SQL resource provider installation files.

    Important

    Use Clear-AzureRmContext -Scope CurrentUser and Clear-AzureRmContext -Scope Process to clear the cache before running the script.

  4. Run the DeploySqlProvider.ps1 script by using the following parameters:

    • Uninstall: Removes the resource provider and all associated resources.
    • PrivilegedEndpoint: The IP address or DNS name of the privileged endpoint.
    • AzureEnvironment: The Azure environment used for deploying Azure Stack Hub. Required only for Microsoft Entra deployments.
    • CloudAdminCredential: The credential for the cloud admin, necessary to access the privileged endpoint.
    • AzCredential: The credential for the Azure Stack Hub service admin account. Use the same credentials that you used for deploying Azure Stack Hub. The script fails if the account you use with AzCredential requires multifactor authentication (MFA).

To remove the SQL resource provider V2

  1. Sign in to the Azure Stack Hub administrator portal.

  2. Select Marketplace Management on the left, and then select Resource providers.

  3. Select SQL resource provider from the list of resource providers. To find the SQL resource provider, filter the list by entering SQL Server resource provider or MySQL Server resource provider in the search text box.

    Select RP in the Marketplace

  4. Select Uninstall from the options at the top of the page.

    Screenshot of selecting Uninstall in the Marketplace

  5. Enter the name of the resource provider, and then select Uninstall. This action confirms your desire to uninstall:

    • The SQL Server resource provider.
    • All admin/user created SKU/Quota/HostingServer/Database/Login metadata.

    ![Screenshot of confirming Uninstall

  6. (Optional) If you want to delete the installation package, after uninstalling the SQL resource provider, select Delete from the SQL resource provider page.

    Delete package

Next steps

Offer App Services as PaaS

  • Last updated on