Property Owner is not available for Database ‘[DBName]’ – error

When you right-click on the database and choose properties, it can happen that instead of getting the database properties window, you get the error message:

Cannot show requested dialog. (SqlMgmt)
Property Owner is not available for Database '[DBName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

It can happen when account that was the owner of the database was removed from the system, leaving the database with no owner, or if the database owner name is not a valid login in the SQL Server instance where you have attached or restored the database.

To fix the problem, change the owner of the database using the following code:

For example:

USE DBName
EXEC sp_changedbowner 'Login_Name'

or:

ALTER AUTHORIZATION ON DATABASE::Database_Name TO "Login_Name"
GO

If the post helped you, please share it:
Pin It

2 comments to Property Owner is not available for Database ‘[DBName]’ – error

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">