Home > Management Studio, SQL Bugs, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012 > Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) – SQL Server ‘Denali’

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) – SQL Server ‘Denali’


Today morning, I read a post on Pinal’s blog. I tried to reproduce the issue, but was unable to do so. Instead, I ran into a different error:

image

However, this does not stop you from connecting.

image

You can see from the screen shot that I was able to connect to the Instance, despite the error message. Also, I can access the data without any issues.

image

I was a bit curious and also tried this on SSMS 2005. And guess what, the same error appears there:

4. Error From SSMS 2005

But the consequences are more “SEVERE” in SSMS 2005. You can access the Database, execute queries against it without any issues.

However, the Object Explorer tree does not expand.

5. Cannot Expand From Object Explorer

Connect Feedback Item : https://connect.microsoft.com/SQLServer/feedback/details/666386/index-was-outside-the-bounds-of-the-array-microsoft-sqlserver-smo-while-connecting-from-ssms-2005-2008

Hope This Helps!

Vishal

  1. pinaldave
    03.05.2011 09:49 | #1

    Hi Vishal,

    Thanks for blog post however, this is more like accident.

    Thanks again, and keep up good work.

  2. Herme
    10.05.2011 06:28 | #2

    There is a fix for this – at least for SQL 2008 and SQL 2008 R2. It can be found here in this KB article:

    http://support.microsoft.com/kb/2459027

  3. Vishal
    10.05.2011 07:17 | #3

    Thanks Herme.

  4. Rajesh Kumar
    06.07.2011 01:10 | #4

    There is a fix for this – at least for SQL 2008 and SQL 2008 R2. It can be found here in this KB article:

  5. Raj
    25.02.2013 12:44 | #5

    this error to solve through 2008-r2 or 2012

  6. Thak
    25.02.2014 03:28 | #6

    It doesnt work for 10.0.1600.22 version, which is currently available on Microsoft site..
    SQLManagementStudio_x64_ENU.exe and it still have the same error.

  7. Rob
    23.09.2014 05:32 | #7

    Index was outside the bounds of the array. Sorry didn’t put this down on first post

  1. No trackbacks yet.