Property Owner not available for database

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 

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s