SQL ARM template is failing

sns 9,226 Reputation points
2023-03-24T07:31:37.56+00:00

Hi

I tried to deploy ARM template but it is failing at SQL db server , please see below error and suggest what needs to be done to fix , what exactly needs to be done to fix this. Please suggest

User's image

Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,129 questions
0 comments
Accepted answer
  1. Raviraj Nallasivam 170 Reputation points
    2023-03-24T13:40:49.58+00:00

    MySQL Server 5.6 version retired as of Feb 2021.

    User's image

    For more information, please refer https://learn.microsoft.com/en-us/azure/mysql/concepts-version-policy#supported-mysql-versions

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erkan Sahin 830 Reputation points
    2023-03-25T10:37:51.8266667+00:00

    If you are encountering an error stating that version 5.6 is not supported when attempting to deploy an ARM template with an Azure SQL Database server, this may be because you are attempting to use an outdated or unsupported version of SQL Server.

    To resolve this issue, you may need to update your SQL Server version to a supported version that is compatible with your ARM template. Here are some steps you can follow to troubleshoot and resolve this issue:

    1. Verify the SQL Server version: Check the version of SQL Server that is currently installed on the machine where you are running the ARM template deployment. You can do this by running the following query in SQL Server Management Studio:

    SELECT @@VERSION

    1. Check the ARM template: Verify that the ARM template specifies a supported version of SQL Server. You can check the supported versions of SQL Server by referring to the Azure SQL Database resource provider API version documentation.
    2. Update SQL Server: If the version of SQL Server that you are currently using is not supported, you may need to update it to a supported version. You can download the latest version of SQL Server from the Microsoft Download Center.
    3. Modify the ARM template: If you are unable to update SQL Server, you may need to modify the ARM template to specify a supported version of SQL Server. You can do this by updating the version number in the ARM template to match the supported version.
    4. Retry the deployment: After updating SQL Server or modifying the ARM template, retry the ARM template deployment to see if the issue has been resolved.

    If the issue persists or you need additional assistance, you may want to consider reaching out to Azure support for further guidance.

    0 comments