User Profile Synchronization
Event Log:
The server encountered an unexpected error and stopped.
”ERR: MMS(1516): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1516): sql.cpp(5601): Error retrieving error
BAIL: MMS(1516): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_25480d71476c456e861f8d660a1eb297 on TSTMSDB02
BAIL: MMS(1516): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 0.
ERR: MMS(1516): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1516): sql.cpp(5601): Error retrieving error
BAIL: MMS(1516): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_25480d71476c456e861f8d660a1eb297 on TSTMSDB02
BAIL: MMS(1516): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 1.
ERR: MMS(1516): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1516): sql.cpp(5601): Error retrieving error
BAIL: MMS(1516): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_25480d71476c456e861f8d660a1eb297 on TSTMSDB02
BAIL: MMS(1516): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 2.
ERR: MMS(1516): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1516): sql.cpp(5601): Error retrieving error
BAIL: MMS(1516): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_25480d71476c456e861f8d660a1eb297 on TSTMSDB02
BAIL: MMS(1516): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1516): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1516): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 3.
BAIL: MMS(1516): service.cpp(991): 0×80230406 (An error has occurred at the store)
Forefront Identity Manager 4.0.2450.11″
Solution:
Cumulative Update from 31. August 2010.
- Install SharePoint Foundation 2010 hotfix KB 2352346 and restart server
- Install SharePoint Server 2010 hotfix KB 2352342 and restart server
- Delete and Config the User Profile Service again.
It was very interesting for me to read this article. Thanks for it. I like such themes and everything connected to them. I would like to read more on that site soon. BTW, rather good design you have here, but what do you think about changing it once in a few months?
Jane Pingtown
What do you think about adding some more illustrations? I don’t want to offend anyone, content is really nice. Just according to the scientists visitors acquire information much more effective if they see some helpful illustrations.
Steaven Drawledge