Thursday, July 11, 2013

Property Owner is not available for Database SSMS error

When you try to launch the database mirroring GUI or some other database property window in SSMS you get this error:

Cannot show requested dialog.

Additional information:
  Cannot show requested dialog.(SqlMgmt)
    Property Owner is not available for Database'[XXXX]'. This property may not exist for this
    object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
I saw this issue during our DR (Disaster Recovery) exercise. We were using the SSMS GUI and we successfully failed over one database from the principle server to the mirror server, but when we did a failback via the GUI we got this error.Visit below link to troubleshoot this issue:

Property Owner is not available for Database SSMS error

Visit my author profile to read my other articles: Manvendra Deo Singh

1 comment:

Anonymous said...

This is really interesting, You're a very skilled blogger.

I've joined your feed and look forward to seeking more of your wonderful post.
Also, I have shared your website in my social networks!

Also visit my homepage :: Cubes Craft HD android hack tool telecharger