Property Owner is not available for Database error message

When clicking on Properties, SQLServer could display the following error message “Property Owner is not available for Database ‘[DatabaseName]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)”

One of the reason why this may occur if the login in the database was deleted and the login was the owner of the database.

The following steps show how to create the error:
1) Shows the database and the owner of the database
select name, suser_sname(owner_sid), owner_sid from sys.databases
where name = ‘test11’

test11 MACHINE\TESTUSER 0x010500000000000515000000F7146062B29A0B760E3FB9BDF8030000

2) The login was deleted in SQLServer

3) When you rerun to check the owner of the database and when you now click on properties of the database it will show that error.
select name, suser_sname(owner_sid), owner_sid from sys.databases
where name = ‘test11’
test11 NULL 0x010500000000000515000000F7146062B29A0B760E3FB9BDF8030000

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s