Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Sunday, February 9, 2014

Database does not have a valid owner - SQL restore error

Hi,

"Database diagram support object cannot be installed because this database does not have a valid owner".

You may get this error while restoring the database from external source (in *.bak format).

Solution:

Right click on the database properties in the permission tab select grand privilege to all( tick the check box).

now error free for restore.

Regards,

No comments:

Post a Comment

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,