Post reply

Unable to access Database during monitoring...Plz help me out

  • May 6, 2009 at 12:56 am

    #132123

    Hi frnds,

    During monitoring i am unable to access one database, It is showing some information i.e. "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)".

    Plz help me out to access this database.

    Thanks,

    Abhishek

  • May 6, 2009 at 2:03 am

    #989365

    Does the login you are using have rights on that DB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 6, 2009 at 5:20 am

    #989430

    It sounds like your monitoring app is issuing a sp_helpdb command against a databases which has an owner which does no longer exists.

    This can happen when a windows login is owner of the database and then someone deletes the windows login from AD.

    [font="Verdana"]Markus Bohse[/font]

  • May 6, 2009 at 5:28 am

    #989433

    this usually happens when the owner of a database is dropped. Try setting

    the owner of the database to an exisiting account or sa, using this command:

    use

    go

    sp_changedbowner 'sa'

    go

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • May 7, 2009 at 12:44 am

    #990150

    Thanks a lot........to u all...

    i got the real idea behind it.

    thanks again...

  • May 7, 2009 at 12:46 am

    #990152

    thank you markus, it really helpful

Viewing 6 posts - 1 through 5 (of 5 total)

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