This is known issue with SQL Server 2008 R2 Management Studio while connecting to SQL Server 2012.There are no claims on what features may/may-not work, and this is expected behavior.

There were errors in basic connectivity and those have been fixed in the past.

For example, http://support.microsoft.com/kb/2459027/EN-US (FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008)

FIX:

To use all features of SSMS, use the same version as MSSQL Server engine (i.e. MSSQL Server 2012 / MSSQL Server 2012 Management Studio Express)

(7 vote(s))

Helpful

Not helpful

Comments (0)

Post a new comment

Reply to comment

Full Name:

Email:

Comments:

CAPTCHA Verification

Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).