Monday 22 August 2016

Cannot show requested dialog. (SqlMgmt) Property Owner is not available for Database


When I try to access database properties in SSMS, I faced below error.



This error looks like permission issue, but this is because of database owner was NULL. Not sure how owner changed to NULL.

Run below query to find owner of specific database

SELECT name,
       suser_sname(owner_sid) AS owner
FROM   sys.databases where name = 'DBName'
Change owner of database from NULL to SA
USE DBName
EXEC sp_changedbowner 'sa'


Now you can access properties of database in SSMS