Avamar SQL backup fails with "SQL Server WMI provider is not available"

           

   Article Number:     498926                                   Article Version: 4     Article Type:    Break Fix 
   

 


Product:

 

Avamar Plug-in for SQL,Avamar

 

Issue:

 

 

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    
   
   
     
                                                           

 

 

Cause:

 

 

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.
                                                           

 

 

Resolution:

 

 

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.