The designer encountered an error while loading the table definition?

Question

I've problem with Visual Studio 2012 Ultimate.

I inserted a "Sql Server Database", and when I try to "Add new table" after a while I get this problem

The designer encountered an error while loading the table definition

and two errors in "Error List"

1. The target database schema could not be retrieved. Unable to reconnect to database.

2. Failed to obtain schema information from database (LocalDB)\v11.0.C:\USERS\SRDJAN\DOCUMENTS\VISUAL STUDIO 2012\WEBSITES\WEBSITE3\APP_DATA\DATABASE.MDF.
   Please close any open editors for this database, check your connection to this database, and refresh the database in Server Explorer. C:\USERS\SRDJAN\DOCUMENTS\VISUAL STUDIO 2012\WEBSITES\WEBSITE3\APP_DATA\DATABASE.MDF

What can I do to get this working?

Answer 1

I had the same issue, but it get resolved when I use "SQL Server Object Explorer" instead of "server explorer" to add new tables.

Answer 2

Please check that the login you are using to connect to the database in VS has the necessary permissions to create tables.