Avamar: SQL Plug-in Failed to Browse SQL Instances in a Mixed SQL Environment

Summary: Avamar SQL plug-in failed to browse SQL instances in a mixed SQL environment.

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

Avamar SQL plug-in failed to browse SQL instances in a mixed SQL environment, for example, a SQL server has installed both SQL 2012 and SQL 2014. The error is reported when running the browse command on the SQL server.  
avsql --operation=browse

avsql Info <0000>: <=== sqlconnectimpl::is_SqlServ_2014
avsql Info <19488>: SMO DLL version 12 detected.
avsql Info <0000>: SMO managed DLL loaded for SQL server 2014 (SMO DLL version 12).
avsql Error <40258>: sqlconnectimpl_smo::get_installed_instance_list Microsoft.SqlServer.Management.Smo.FailedOperationException: An
crosoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.Runtime.InteropServic  
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)   
at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()   
.
.
.....SNIP......
.
at SMO_GetInstances(Char* server, Char*** pinstances, Char*** perrors, Boolean include_clustered_servers, Int32 architecture)
avsql Error <15125>: Specified path '' does not exist or is not accessible avsql Info <6451>: avsql returning with exitcode 536870919

Cause

In a mixed environment, for example, SQL 2014 were installed but uninstalled later with some modules of SQL 2014 left on the machine. In this scenario, the Avamar SQL plug-in could not exactly decide the version of Server Management Objects (SMO) to use for the browse and backup.

Resolution

To resolve this issue. 
  • Upgrade the Avamar Server to:
    • 19.4.100-124 or later 
  • The fix is in Avamar 19.4 and later software releases. 
  • A flag must be added to the 'avsql.cmd' parameter file in the Avamar client var directory with the correct SMO value for plug-in operations after upgrading.
    • The following five values are the valid ones.  
    • Choose the highest SQL server instance version for plug-in operations.
      • For SQL Server 2012: --usesmoversion=11
      • For SQL server 2014: --usesmoversion=12
      • For SQL server 2016: --usesmoversion=13
      • For SQL server 2017: --usesmoversion=14
      • For SQL server 2019: --usesmoversion=15
      • For SQL server 2022: --usesmoversion=16

Affected Products

Avamar

Products

Avamar
Article Properties
Article Number: 000051925
Article Type: Solution
Last Modified: 06 Aug 2025
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.