Azue Arc SqlAgent Extension Status Failed or stuck as Creating

Sean I 0 Reputation points
2024-09-17T01:27:08.17+00:00

Many of the Azure Arc Enabled SQL Servers were no longer reporting SQL BPA as being enabled. After some investigation I found that all the servers with issues had the SqlAgent Extension with a Status of failed. I would like to know how that could have happened.

Also, after following the instructions on how to uninstall and reinstall the SqlAgent Extension, I have a few servers that are having trouble with the installation. It either fails or the extension's status is stuck as Creating. I am searching for an answer on how to correct these issues.

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
406 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,739 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,296 Reputation points
    2024-09-18T06:03:41.1+00:00

    Hi Sean I,

    Welcome to Microsoft Q&A forum.

    As I understand, you are experiencing issue in Azure Arc SqlAgent Extension as Failing or Stuck.

    After uninstall and reinstall some still have issue, for such servers could you please ensure that the Azure Arc agent and SQL Server version are up to date and the Azure Arc agent has the necessary permissions to install and manage the SqlAgent extension.

    Check that the machine can communicate with Azure services by verifying outbound internet connectivity.

    Also look at the options suggested in the below mentioned link to troubleshoot:

    https://video2.skills-academy.com/en-us/sql/sql-server/azure-arc/troubleshoot-deployment?view=sql-server-ver16

    Let us know if this helped or you are still stuck.

    Awaiting your reply.
    Thanks

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.