Before some days, I have copied one database from the one of server and restored it on my machine. The server was not having ‘sa’ user login and I was having the ‘sa’ user in my local machine. The database was restored perfectly with no problem but when I tried to create a database diagram I got following error.
Right click on your database and click properties it will open a dialog like following. Goto-> Fiile Tab.
Click on .. button it will open a dialog box like following.
Click on browse button. It will open a list of user available for SQL Server.You need to select user whom you want to make database owner. In my case I want to make ‘sa’ user database owner so that I have selected like following.
After selecting user you need to close all dialog via pressing ‘OK’ buttons. That’s it your database is now having proper owner and error for database diagram is gone now. Hope you like it. Stay tune for more..
After digging into that I found that the database does not have any valid owner and that’s why its generating errors. To resolve this error following is a step to change or add owner of database.Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
Step-1:
Step-2:
Step-3:
After selecting user you need to close all dialog via pressing ‘OK’ buttons. That’s it your database is now having proper owner and error for database diagram is gone now. Hope you like it. Stay tune for more..
0 comments:
Post a Comment
Your feedback is very important to me. Please provide your feedback via putting comments.