Property Owner is not available for Database

ERROR MESAGGE:

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

EXPLANATION:

For example, you may see this error message when you try to look at the properties of a database in SQL Server Management Studio. The reason is that the original owner of the database is changed.

SOLUTION:

As the owner of the database, you can assign the user “sa” as follows.