You Receive Errors When Connecting to MSSQL 2012 Using MSSQL 2008 or 2008 R2 Management Studio

Plesk Servers > SQL > MSSQL
 
You Receive Errors When Connecting to MSSQL 2012 Using MSSQL 2008 or 2008 R2 Management Studio.

Issue
When connecting to SQL server using MSSQL 2008/2008 R2 you receive the following errors:
  • Error message received when right-clicking on a table in database - Index was outside the bounds of the array:

    Error when right-clicking table in SQL Server 2008/2008R2
     
  • Error message received when clicking Design - This backend version is not supported to design database diagrams or tables:

    Error message received when clicking design in MSSQL 2008/2008R2
     
  • Error message received when clicking Edit Top 200 Rows - Invalid prefix or suffix characters:

    Error message received when clicking Edit Top 200 Rows in MSSQL 2008/2008R2

Cause

The server you are connecting to is using SQL Server 2012. The error is a result of incompatibilities with previous versions of SQL Server Management Studio i.e. 2005, 2008, & 2008 R2.

Resolution

You will need to download SQL Server 2012 Management Studio to make changes to your database. You can download it from the MSSQL Express 2012 website.
 

Add Feedback