Wednesday, June 4, 2014

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 back end 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 2014 databases from SQL Server 2012 or SQL Server 2008 R2, 2008 management tools. To fix the issue you need to download updated version of sql server management studio. 

2 comments: