Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dvsrk
Starting Member
2 Posts |
 Posted - 2009-02-20 : 16:35:42
|
| Hi all,I restored my database.when i tried to view the Database Diagrams folder in the restored database. I am popped with a dialogue box containing.."The Database Diagram support objects cannot be installed becoz this database doesn't hav a valid owner."I tried changing the owner then i got this error message."Msg 15353, Level 16, State 1, Line 1.An entity of type database cannot be owned by a role, a group, an approle, or by principals mapped to certificates or asymmetric keys." Help me with this issue |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dvsrk
Starting Member
2 Posts |
Posted - 2009-02-20 : 16:50:43
|
| Hi tkizer,your question make me to try all options.Itz working fine when i set owner to "NT AUTHORITY\SYSTEM".But still i m in confusion with this.Thnaks,dvsrk. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How to deal with error Msg 15353, Level 16