Problem

When trying to view the properties of a database (right click in SSMS on the database and choose Properties from the drop down menu) the following error is displayed:

Cannot show requested dialog. (SqlMgmt)

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)

 

Solution

The problem seems to occur only on one database, for the other the Properties window is displayed without any problem. Also, the account that tries to view the database?s properties is sysasmin, so is not a security related issue which leads us to the conclusion that the problem is somehow database related.

 

...

 

By executing the following stored procedure for that database, the result shows that the owner column has a NULL value:

sp_helpdb Database_Name

To fix this use the sp_changedbowner stored procedure to set the sa login as owner for that database:

USE Database_Name
GO
EXEC sp_changedbowner @loginame = 'sa'

After executing the above code, the Property window for that database is properly displayed.

 

 


No feedback yet

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)