Avamar: SQL Backup Failure - Client Not Browsable - "Error Code: 10007"

Observed Symptoms

SQL Backup failed and the client cannot be browsed in the Avamar administration interface.

• Backup completed with "Error Code: 10007".
• SQL Server Configuration Manager displays the error message "Cannot connect to WMI provider. You do not have permission or the server is unreachable."

Relevant portion from the backup log:

2013-09-23 00:00:01 avsql Info <5008>: Logging to C:\Program Files\avs\var\Daily-12am-RxSQL-1379912400061-3006-SQL.log 2013-09-23 00:00:01 avsql Info <6673>: CTL listening on port 56505 2013-09-23 00:00:01 avsql Info <10684>: Setting ctl message version to 3 (from 1) 2013-09-23 00:00:01 avsql Info <16136>: Setting ctl max message size to 268435456 2013-09-23 00:00:01 avsql Info <7838>: - Adding user exclude "*/tempdb" 2013-09-23 00:00:02 avsql Error <9072>: sqlconnectimpl_smo::get_installed_instance_list Microsoft.SqlServer.Management.Smo.FailedOperationException: An exception occurred in SMO while trying to manage a service. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.Management.ManagementException: Invalid class

Microsoft Windows Management Instrumentation (WMI) Provider Removal

When a SQL Server instance is uninstalled, the WMI provider that supplies configuration information to SQL Server Configuration Manager is removed.

Shared WMI Configuration File

Both 32‑bit and 64‑bit instances of SQL Server reference the same WMI configuration file located in the C:\Program Files (x86)\Microsoft SQL Server\xxx\Shared folder. Deleting the file for one instance removes it for the other.

Impact on Avamar SQL Backup

The missing provider prevents SQL Server Configuration Manager from connecting to WMI, causing the error “Cannot connect to WMI provider. You do not have permission or the server is unreachable.” Avamar relies on this provider to enumerate databases; therefore the client cannot be browsed and the backup terminates with Error Code 10007.

• Uninstall or upgrade of a SQL Server instance removes the WMI MOF file.
• The same MOF file is shared across all instances on the host.
• Avamar backup client cannot retrieve database metadata.

Cannot connect to WMI provider error in SQL Server Configuration Manager (External Link)

Restart WMI Service

1. Open Services console (services.msc).
2. Locate Windows Management Instrumentation service.
3. Right‑click and select Restart.
4. Confirm that the service restarts without errors.

For more info see Microsoft KB  Cannot connect to WMI provider error in SQL Server Configuration Manager (External Link)

Apply Microsoft Knowledge Base Workaround

Open a command prompt with administrative privileges and execute the appropriate command for the SQL Server version. This command re-registers the SQL Server WMI Provider in Windows.

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\<Version>\Shared\sqlmgmprovider.mof"

Verification

1. Open SQL Server Configuration Manager. No error message should appear.
2. In Avamar Admin GUI or AUI, browse to Backup. All SQL instances and databases should be listed.
3. Run a test backup and confirm that it completes without Error Code 10007.