KBI 311175 Index Was Outside The Bounds Of The Array In Argent For SQL Server


Argent Advanced Technology 1501-C and earlier


Wednesday, 11 March 2015


Argent for SQL Server could not retrieve the version of Microsoft SQL Server 2012 because of an exception thrown by the SQL Server Management Object (SMO) component

Technical Background

Argent for SQL Server uses SQL Server Management Object (SMO) for connecting and retrieving Microsoft SQL Server information

Before executing a Rule, Argent checks the version and edition of Microsoft SQL Server to make sure that the version of SQL Server is compatible to the Rule to be executed

Unfortunately one Microsoft product fails to check for the presence of another Microsoft product and SMO blithely assumes that the SQL Server Management Studio is installed

When connecting to the Microsoft SQL Server 2012 machine, the SMO fails if the installed SMO version is wrong

In this case, SMO raises an exception ‘Index was outside the bounds of the array’ and hence Argent is not able to collect the required information

Argent recommends SMO version 10.5.6000.34 (included in Microsoft SQL Server 2008 R2 SP3 Feature Pack) for best results


Install either 64x or 86x versions of the following files from SQL 2008 R2 SP3 package

  • SharedManagementObjects.msi
  • SQLSysClrTypes.msi

The files can be downloaded from the below URL:


Either 64 Bit Version

Or The 32 Bit Version