Property Owner is not available for Database.

Sometimes when you try to open the properties dialog for a database the following error message is displayed:

“Property Owner is not available for Database ‘[<database>]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)”

This error happens when you are trying to access the database options and the database doesn´t have a database owner. This usually happens when the database owner user was deleted and a new database owner hasn´t been assigned to the database.

Assign a new user to the database using sp_changedbowner, for example:
use <databasename>
go
sp_changedbowner ‘sa’
go

The following query lists possible database owners that can be assigned to the database:
select databases.name,server_principals.name
from sys.[databases]
inner join sys.[server_principals]
on [databases].owner_sid = [server_principals].sid
go

There are lots of other blogposts about this issue, here are a couple of examples:
http://sqlpost.blogspot.se/2009/06/sql-server-error-property-owner-is-not.html
http://blog.dampee.be/post/2008/06/22/MSSQL-2005-error-message-quot3bProperty-Owner-is-not-available-for-Database-databaseNamequot3b.aspx

Advertisements

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 )

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