Thursday, May 24, 2012

Index was outside the bounds of the array

I was trying to connect to SQLserver 2012 using SQLserver 2008 Management studio and received below error. I was able to connect and able to query.

I tried the same with SQL2005 Management studio and same error. I didn’t see useful information under Technical details.

Cause: Please note that old versions of SSMS (SQLServer Management Studio) are not forward compatible. Using 2012 SSMS you can connect to SQLServer 2005/2008 databases as it is backward compatible.

It looks like Microsoft will not fix the forward compatiable.

Solution: Upgrade all your client tools to highest version, and then you won't be missing out on any functionality or getting error messages.


Satishbabu Gunukula


  1. Amazing blog! Do you have any suggestions for aspiring writers? I'm planning to start my own blog soon but I'm a little lost on everything. Would you suggest starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm totally overwhelmed .. Any suggestions? Many thanks! best search engine optimization 

  2. Hey! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a wonderful job! singapore e commerce sites