none
Event ID 28005

Answers

  • Hi,

    Run following t-sql query language:

    USE master;
    GRANT IMPERSONATE ON LOGIN::<login name> to [sa];
    GO

    After that, try to change the DB owner to SA to see if it works. Besides, you need to check if login property of 'SA' is locked:

    Select loginproperty('sa','IsLocked')

    if It returned 1

    Which means the SA account is locked because of check policy


    then, used the following Query to change the check_policy to OFF

    ALTER LOGIN SA with CHECK_POLICY = OFF

    HTH.
    Jie-Feng Ren - MSFT
    Thursday, August 20, 2009 8:35 AM

All replies

  • Hi,

    First, check following KB article:

    941409 The Discovery Wizard may stop responding during the discovery process in Microsoft System Center Operations Manager 2007
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;941409

    Also, change Operation manager DB owner to 'SA', Then, try to see if it works.

    HTH.


    Jie-Feng Ren - MSFT
    Wednesday, August 19, 2009 6:15 AM
  • 941409 The Discovery Wizard may stop responding during the discovery process in Microsoft System Center Operations Manager 2007
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;941409

    i follow this solutions : is_broker_enabled




    when i try to change operation manager DB owner this message shown to me .



    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Cannot show requested dialog.

    ------------------------------
    ADDITIONAL INFORMATION:

    Cannot show requested dialog. (SqlMgmt)

    ------------------------------

    Property Owner is not available for Database '[OperationsManager]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)




    need your advise ...


    MCP MCSA MCSE MCT
    Wednesday, August 19, 2009 7:08 AM
  • Hi,

    Run following t-sql query language:

    USE master;
    GRANT IMPERSONATE ON LOGIN::<login name> to [sa];
    GO

    After that, try to change the DB owner to SA to see if it works. Besides, you need to check if login property of 'SA' is locked:

    Select loginproperty('sa','IsLocked')

    if It returned 1

    Which means the SA account is locked because of check policy


    then, used the following Query to change the check_policy to OFF

    ALTER LOGIN SA with CHECK_POLICY = OFF

    HTH.
    Jie-Feng Ren - MSFT
    Thursday, August 20, 2009 8:35 AM
  • Hi,

    Run following t-sql query language:

    USE master;
    GRANT IMPERSONATE ON LOGIN::<login name> to [sa];
    GO

    After that, try to change the DB owner to SA to see if it works. Besides, you need to check if login property of 'SA' is locked:

    Select loginproperty('sa','IsLocked')

    if It returned 1

    Which means the SA account is locked because of check policy


    then, used the following Query to change the check_policy to OFF

    ALTER LOGIN SA with CHECK_POLICY = OFF

    HTH.
    Jie-Feng Ren - MSFT

    thanks for your help ...

    no i can discovery process completed

    thannx man
    MCP MCSA MCSE MCT
    Thursday, August 20, 2009 1:41 PM