Tuesday, August 20, 2013

This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

You may receive the below error and couple of other errors while working with SQL Server 2012

This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
Index was outside the bounds of array (Microsoft.SQLServer.SMO)

Workaround

The errors may happen because you are trying to access SQL Server 2012 databases from SQL Server 2008 or SQL Server 2008 R2 management tools. To fix the issue you need to download SQL 2012 management tools.
 

3 comments:

  1. Maybe you could be helpful and specify HOW/WHERE to download SQL 2012 Management Tools??!

    ReplyDelete
    Replies
    1. http://lmgtfy.com/?q=HOW%2FWHERE+to+download+SQL+2012+Management+Tools%3F%3F!

      Delete
  2. Thanks for the info

    ReplyDelete