SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

Background

Drew a quick error running Sql Server Management Studio (SSMS).

Error

Text

The error reads :-

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

Image

SSSM.v2008.IndexWasOutsideTheBoundsOfTheArray.20190203.0652AM.PNG

Explanation

  1. Error reads
    • Microsoft.SqlServer.Smo
    • Index was outside the bounds of the array

Recreate

Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008.

 

TroubleShooting

Microsoft.SqlServer.Smo

SysInternals / Process Explorer

Version

Outline
  1. Download SysInternals \ Process Explorer
  2. Launched SysInternal’s Process Explorer
  3. Selected the ssms.exe
  4. View process modules
    • Click on menu “View”\”Show Lower Pane”
  5. Find
    • Click on menu and choose Find
    • Enter smo
    • Reviewed found modules
  6. Launched Windows Explorer
  7. Accessed the found DLL
  8. Noted version number as 10.0.1600.22
Images
Image – Process Explorer

processExplore.20190203.0957AM.PNG

Image – Handle or DLL substring

findModule.smo.PNG

Windows Explorer

ssmo.sysInternals.processExplorer.20190203.0720AM.PNG

Remediation

Microsoft SQL Server 2008 Service Pack 4 Feature Pack

SQL Server SMO is bundled as part of SQL Server Feature Pack.

The latest version is Service Pack 4 and it is available here.

Packages

  1. Shared Management Objects
    • ENU\X86\SharedManagementObjects.msi
  2. Clr Types
    • ENU\X86\SQLSysClrTypes.msi

Outline

  1. Download
    • Download ENU\X86\SharedManagementObjects.msi
    • Download ENU\X86\SQLSysClrTypes.msi
  2. Install
    • Install SQLSysClrTypes.msi
    • Install SharedManagementObjects.msi

Screenshot

Download

SQL System CLR Types

clrtypes.20190203.0732AM.PNG

Management Objects

microsoft.smo.20190203.0728AM.PNG

Installation

Management Objects
Prerequisite – Missing Microsoft SQL Server 2008 System CLR Types

clrtypes.20190203.0730AM.PNG

Welcome

microsoft.smo.welcome.20190203.0733AM.PNG

System CLR Types
Installation – SQL Server 2008 System CLR Types

clrtypes.welcome.20190203.0732AM.PNG

Post Installation Review

Outline

  1. Post Installation
    • Microsoft.SqlServer.Smo.dll
    • Version
      • Moved from 10.0.1600.22 to 10.0.6000.29

Images

WindowsExplorer.Microsoft.SqlServer.smo.dll.20190203.1028AM.PNG

Acknowledged

Acknowledged Giles D Middleton.

GilesDMiddleton.20190203.1041AM

 

References

  1. stack overflow
    • Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)
      Link
  2.  Microsoft
    • Microsoft SQL Server 2008 Service Pack 4 Feature Pack
      Link

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s