Avamar: SQL Backup failed, client is not browsable, backup failed with Error Code: 10007

Summary: SQL Backup failed, client is not able to browse, and backup failed with an Error Code: 10007.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

SQL Backup failed, the client is not able to browse, and the backup completed with an Error Code: 10007

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

 

When customer opens SQL Server Configuration Manager in SQL Server the error message is: "Cannot connect to WMI provider. You do not have permission or the server is unreachable.

SQL configuration Manager icon

 

Cause

It is a Microsoft WMI issue as per the Microsoft KB article:
https://learn.microsoft.com/en-us/troubleshoot/sql/tools/error-message-when-you-open-configuration-manager This hyperlink is taking you to a website outside of Dell Technologies.

"This problem occurs because the WMI provider is removed when the customer uninstalls an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the "C:\Program Files (x86)\Microsoft SQL Server\xxx\Shared" folder.

This can sometimes happen during SQL updating.

Resolution

If restarting of WMI service on the affected SQL client does not resolve the issue, follow as per Microsoft KB:
https://learn.microsoft.com/en-us/troubleshoot/sql/tools/error-message-when-you-open-configuration-manager This hyperlink is taking you to a website outside of Dell Technologies.

To work around this problem, open a command prompt, type the following command, and then press ENTER:
For example: For Windows SQL 2008/ R2 server the command line is: 
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
Later versions SQL 2022
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\160\Shared\sqlmgmprovider.mof"

After that make sure, customer can open SQL Server Configuration Manager in SQL Server without any error and the SQL client can browse in Avamar Admin GUI or AUI --> Backup and all instances/DBs are listed.

 

Affected Products

Avamar Plug-in for SQL
Article Properties
Article Number: 000040204
Article Type: Solution
Last Modified: 11 Jul 2024
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.