Database diagram support objects cannot be installed Resolved !

 

Hi,

In the below post you will see how we can resolve the database diagram support related message and how we can create new database diagram for AdventureWorks database which we have attached earlier post.

When you have attach the database file of another sql server instance , In this case it may possible that the database login name of that database is not valid for the current sql server. So In this case you need to update the authorization of the database using the alter command .

For example, I was getting warning message when I clicked the database diagram for the AdventureWorks database which I attached earlier.

image

So below is the command which resolved this.

image

Here the “AdventureWorks2008” is my database name and “sa” is the user for which we want the permission.

After this when you right click the database diagram you got below message ,

image

Select the new database diagram , It will display another popup message.

image

Click on YES , after that add Table dialog will appears.

image 

Select all tables and click on Add button.

image

After successful processing the database diagram created for you .

image

Thanks for reading ,Hope you find this post useful 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s