Monday, 30 April 2012

Error property owner is not available for Dataabse. This property may not exists for this object, or may not be retrievable due to insufficient access rights.

Got this Error property owner is not available for Dataabse. This property may not exists for this object, or may not be retrievable due to insufficient access rights. I couldn’t go into the Database properties to change some settings.


Here is how I fixed it:

Run this Stored Procedure to check if the owner is to figure out who is owner of the database.

sp_helpdb

For us the owner was set to NULL, executed the following SQL Query on the database.

USE VIM_VCDB
EXEC sp_changedbowner 'sa'

Note VIM_VCDB was the database name

This worked for me now able to access the propety pane.


No comments:

Post a Comment