|Article Number: 498926||Article Version: 4||Article Type: Break Fix|
Avamar Plug-in for SQL,Avamar
Avamar SQL backups may fail with errors similar to the following below:
avsql Error <40258>: sqlconnectimpl_smo::get_installed_instance_list Microsoft.SqlServer.Management.Smo.SmoException: SQL Server WMI provider is not available on SQLMACHINE. ---> System.Management.ManagementException: Invalid namespace
The Backup Agent (avagent) service is running with a NT domain user account, even if that account has the sysadmin role assigned to it in SQL Server Management Studio.
By default, the avagent service runs with the default local SYSTEM account.
Change the avagent service account back to local SYSTEM and restart the service for the changes to take effect. Make sure that the "NT Authority\SYSTEM" account has the sysadmin role assigned to it in SQL Server Management Studio.
If the above workaround is not feasible, then open a new service request with DELL EMC support and reference this KB article.