I recently downloaded SQL Server developer tools code name "Juneau" as part of Microsoft Visual Studio in order to connect to a remote SQL Server database. I was able to add the SQL Server and it connected. I browsed on the remote server to my database and expanded it, etc. I tried to add a table. I received the following error message: Problem Loading: The designer encountered an error when loading the table definition. The Design window had this message: "The target database could not be retrieved so an update could occur. The reverse engineering could not continue because you do not have View any Definition permission on the server 'SERVER NAME'."
In the past when I used the old Enterprise Manager, I never had this problem. Any ideas on how to fix this? Am I using the right tool?