Database Diagram Creation Error

Hi Scholars,

When I'm trying to create a database diagram for my tables., First it prompts me saying that - "This database does not have one or more of the supported objects... Do you wish to create them? I know this is normal when you don't have any diagrams. But after clicking "Yes", I get the following error which is attached.

I tried changing the database Owner to "sa". But, still the same error. Interestingly, other databases that are already having the database diagrams (created by others), are allowing me to create new diagrams in those databases. 

The only difference is, I created this database where I'm trying to create diagrams on. 

Please suggest me how do I get this working.

Thanks in advance

Below is Error Message:




August 29th, 2015 6:16pm

Hi All,

Yes, it is actually because I have created the database. And looks like I have no sufficient permissions to create DB Diagrams. I overcame this issue by asking my Manager to create a dummy DB and copied over the table schema to it, and then I was able to create the DB Diagrams. So definitely it is something with the Grant permissions for my Login.

Thanks

Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2015 2:39pm

Hi StudentOnline,

Glad to hear that the issue is resolved. You can mark your reply as answer, that way, other community members could benefit from your sharing.



Thanks,
Lydia Zhang

September 4th, 2015 3:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics