• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

SQL server connection issue

Hello experts,
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?

Thanks!
0
snix123
Asked:
snix123
  • 2
2 Solutions
 
BrandonGalderisiCommented:
The problem is that while you have the create table permissions (presumably) you don't have the permissions necessary to use MS dev tools for schema management.  Same error you will get if you try creating a VS DB project.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What are your permissions in the database?
0
 
snix123Author Commented:
Thanks for the replies.  I will check on the permissions.
0
 
snix123Author Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now