Share via

Azure extension for SQL Server install problem

mara7 161 Reputation points
2024-02-28T00:18:31.44+00:00

Hello, I have one WS 2012 R2 datacenter and 2016 sql server. I connected machine on Azure Arc via Arc SQL script. But after 1 weeks, Azure Arc disconnected and I tried connect via connect command.

(azcmagent connect --location "Koreacentral" --resource-group~)

So, I connected Azure Arc machine, but when I enter SQL configuration, I found this Error message "There are SQL Server instances discovered on your server, however the Azure extension for SQL Server was not found" User's image

How do I do? Is it right solutions? or There is another solutions? https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/connect-with-installer?view=sql-server-ver16#deploy-sql-server-extension-from-azureextensionforsqlservermsi

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
337 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalla-MSFT 12,041 Reputation points
    2024-02-28T15:57:43.0433333+00:00

    @mara7 - Thanks for reaching out to us.

    In order to connect your SQL Server instance to Azure Arc on an Arc-enabled server, please follow below:

    If the machine with SQL Server is already connected to Azure Arc, to connect the SQL Server instances, install Azure extension for SQL Server. The extension is in the extension tab of "Server -Azure Arc" resource as Azure Extension for SQL Server.

    To install the Azure extension for SQL Server, use the following steps:

    1. Open the Azure Arc > Servers resource.
    2. Search for the connected server with the SQL Server instance that you want to connect to Azure.
    3. Under Extensions, select + Add.
    4. Select Azure extension for SQL Server and select Next.
    5. Specify the SQL Server edition and license type you are using on this machine. Some Arc-enabled SQL Server features are only available for SQL Server instances with Software Assurance (Paid) or with Azure pay-as-you-go. For more information, review Manage SQL Server license type.
    6. Specify the SQL Server instance(s) you want to exclude from registering (if you have multiple instances to skip, separate them by spaces) and select Review + Create.
    7. Select Create.

    Here is the document for reference: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/connect-already-enabled?view=sql-server-ver16

    Hope this helps. and please feel free to reach out if you have any further questions.

    If the above response was helpful, please feel free to "Accept as Answer" and click "Yes" so it can be beneficial to the community.