Tuesday, October 22, 2013

Property Owner is not available for SQL Server Database error

Property Owner is not available for Database

Error Details:

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


During one of Knowledge Transfer I tried to open the database properties but it was throwing error like below, so I had ran sp_helpdb command to check the database properties and noticed that the owner column was set to UNKNOWN as below. It seems the actual database owner left the company and dropped his login, that's the reason I got below errror.




Solution:
To fix this property owner of sql server database, we need to run below command on the server.

USE DATABASE_NAME
GO
sp_changedbowner 'Domain/User_Nmae'
GO

If your sql server database owner property is not located, then you won’t be able to launch the graphical interface of the database property page whether it's for, database properties, or database-mirroring, or log-shipping or or any other database property window.

0 comments:

Post a Comment