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.
404 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,690 questions
{count} votes

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.