SQL SERVER Properties owner is not available for database XXX. The object may not have this property, or it may be insufficient access to retrieve it.

A case was encountered today: The following error message appears when you right-click a property of a database:

Property owner is not available for database XXX, the object may not have this property, or it may be insufficient access to retrieve.

The owner of the database was found to be null when the script was used to view the owner. The reason is because the owner of the database is a system administrator's account, because the colleague left, the system administrator took the account cleared, so the above error. The following script is queried to find that the owner is a null value.

SELECT D.name,

Owner_sid,

L.name

 from sys.databases D

 Left JOIN  on l.sid = D.owner_sid

WHERE d.name=' DataBaseName ';

You only need to change the owner of the database to the account of SA or other sysadmin role.

 Use DataBaseName;

GO

EXEC ' sa ';

GO

SQL SERVER Properties owner is not available for database XXX. The object may not have this property, or it may be insufficient access to retrieve it.