Discovery of SQL Server resources on Azure VM fails
Issue
Discovery of Azure VMs is triggered, however, the SQL server instances and its databases are not listed. On the Subscription page, the status intermittently shows “Last Sync Failed / Last Sync Error".
Cause
You get this error when the antivirus blocks the PowerShell scripts on the SQL Server.
Resolution
To discover and back up SQL Server on Azure VM, make sure you exclude the following folder under the Antivirus exclusion section:
C:\Packages\Plugins\Microsoft.CPlat.Core.RunCommandWindows
Discovery or authentication fails
Issue
Manual discovery or assign authentication fails and you get the following error:
Cause
You may get this error in the following situations:
You trigger discovery when subscriptions sync is in progress.
Discovery of VMs is already in progress and you retrigger the discovery process.
You try to assign authentication when discovery is in progress.
Resolution
Retrigger discovery or assign authentication after the ongoing discovery operation is completed.