none
Failed to connect to the database FIMSynchronizationService on FIMTEST RRS feed

  • Question

  • Hi All,

    The service FIMSynchronizationService is not starting at all, in event logs the below are the details.

     

    The server encountered an unexpected error and stopped.

     "ERR: MMS(3984): sql.cpp(5583): Query (CSession::Open()) performed with error
    ERR: MMS(3984): sql.cpp(5604): Error retrieving error
    BAIL: MMS(3984): sql.cpp(571): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(387): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(259): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): storeimp.cpp(275): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): server.cpp(297): Failed to connect to the database FIMSynchronizationService on FIMTEST
    BAIL: MMS(3984): server.cpp(298): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): server.cpp(3696): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): service.cpp(1531): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): service.cpp(980): Error creating com objects. Error code: -2145188858. This is retry number 0.
    ERR: MMS(3984): sql.cpp(5583): Query (CSession::Open()) performed with error
    ERR: MMS(3984): sql.cpp(5604): Error retrieving error
    BAIL: MMS(3984): sql.cpp(571): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(387): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(259): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): storeimp.cpp(275): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): server.cpp(297): Failed to connect to the database FIMSynchronizationService on FIMTEST
    BAIL: MMS(3984): server.cpp(298): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): server.cpp(3696): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): service.cpp(1531): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): service.cpp(980): Error creating com objects. Error code: -2145188858. This is retry number 1.
    ERR: MMS(3984): sql.cpp(5583): Query (CSession::Open()) performed with error
    ERR: MMS(3984): sql.cpp(5604): Error retrieving error
    BAIL: MMS(3984): sql.cpp(571): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(387): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(259): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): storeimp.cpp(275): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): server.cpp(297): Failed to connect to the database FIMSynchronizationService on FIMTEST
    BAIL: MMS(3984): server.cpp(298): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): server.cpp(3696): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): service.cpp(1531): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): service.cpp(980): Error creating com objects. Error code: -2145188858. This is retry number 2.
    ERR: MMS(3984): sql.cpp(5583): Query (CSession::Open()) performed with error
    ERR: MMS(3984): sql.cpp(5604): Error retrieving error
    BAIL: MMS(3984): sql.cpp(571): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(387): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): sql.cpp(259): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): storeimp.cpp(275): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): server.cpp(297): Failed to connect to the database FIMSynchronizationService on FIMTEST
    BAIL: MMS(3984): server.cpp(298): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): server.cpp(3696): 0x80230406 (An error has occurred at the store)
    BAIL: MMS(3984): service.cpp(1531): 0x80230406 (An error has occurred at the store)
    ERR: MMS(3984): service.cpp(980): Error creating com objects. Error code: -2145188858. This is retry number 3.
    BAIL: MMS(3984): service.cpp(994): 0x80230406 (An error has occurred at the store)
    Forefront Identity Manager 4.0.2592.0"

     I am thinking of unstall FIMcync Engine. Any Pointer or hint greatly appreciated.

    Regards,
    Anirban

    Sunday, March 22, 2015 11:51 AM

All replies

  • Please check if you FIMSync account has permissions to "logon as a service."

    I faced it once after GPO hardening.

     

    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    Sunday, March 22, 2015 1:50 PM