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