Post reply

Problem opening database properties

  • December 18, 2007 at 2:15 am

    #119366

    Hi All

    I have a problem and I think this is the right forum to post it.

    I have an SQL server that I have removed from the domain and that has prompted that I can't open the properties of any database. I get the following error when I try: Property Owner is not available for Database 'Database name'. This property may not exist for this object, or may not be retrievable due to insufficeint access rights.

    I have tried to look at our application databases and it does not have any of the old domain user names. However the master database still uses an domain user for the RSExecRole I have tried to make another user who have the same role, but it does not help.

    So could you please help me.

    Kind regards

    Bo

  • December 18, 2007 at 5:22 am

    #760948

    First try to use sp_ChangeDBOwner to change the database owners to sa.

    If you cannot get that to work, detach and re-attach your databases.

  • December 18, 2007 at 5:58 am

    #760963

    Thanks the reattach works.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply