KBI 311175 Index Was Outside The Bounds Of The Array In Argent For SQL Server
Version
Argent Advanced Technology 1501-C and earlier
Date
Wednesday, 11 March 2015
Summary
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
Resolution
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:
http://www.microsoft.com/en-us/download/details.aspx?id=44272
Either 64 Bit Version
Or The 32 Bit Version
