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

SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule

Last month I was working on a SQL Server 2005 to SQL Server 2008 R2 upgrade.  Unfortunately, we were not able to complete our upgrade because of a failing a upgrade rule named "Security Group SID (Security Identifier)".  The SQL Server Upgrade Setup Wizard did not enable the 'Next' button in order to proceed with the upgrade until this failure was resolve.  In this tip, I will describe the reason for this failure and how I fixed the issue in order to have a successful upgrade. Read my article published on MSSQL Tips through below link:-

SQL Server 2008 R2 Upgrade Failure due to Security Group upgrade rule 

 

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