Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ?

Leave a comment (0) Go to comments

Can We connect to SQL Server Denali using 2008 SSMS ?

YES, we can connect to SQL Server DENALI (2011) from a SSMS of 2008. But you will get a error message stating "Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)" while connecting to SQL Server Denali from SSMS of 2008/2008R2.

Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ? When trying to register/connect to SQL Server CTP0 Instance from client desktop using SSMS 2008 we get an error: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Index was outside the bounds of the array SQL Server Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

This is BUG, which was confirmed by Microsoft. SQL 2008 SSMS won’t allow you to connect to a Denali SQL Server. This has been fixed in a later build and will be available in the next CU for SQL 2008 and
SQL 2008 R2 SP1.

Regardless of this above error, you can start using SQL Server Denali using 2008/2008 R2 SSMS. I avoided this message and continue to work and it worked for me.


Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ? When trying to register/connect to SQL Server CTP0 Instance from client desktop using SSMS 2008 we get an error: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Index was outside the bounds of the array SQL Server Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

Solution : Update your SSMS with latest available Cumulative Update (CU) / Service Pack (SP).

If you liked this post then,

Subscribe to this Blog via Email:

Click here to Subscribe to FREE email updates from "DBATAG ", so that you do not miss out anything on SQL Server !!!

Tags : Index was outside the bounds of the array SQL Server,When trying to register/connect to SQL Server CTP0 Instance from client desktop using SSMS 2008, we get an error: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo),"Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)"

EOF - Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.