The other day when trying to access the properties of a SQL Server database I received the following error.
Cannot show requested dialog.
Property Owner is not available for Database ‘[database_name]’. This property may not exists for this object, or may not be retrievable due to insufficient access rights.
It turns the fix was very simple. The database did not have an owner. Assigning an owner allowed me to access the database properties once again.
exec sp_changedbowner @loginame = "DOMAIN\username" , @map= remap_alias_flag