I have a FIM server that is synchronising identities from an ADLDS through to an SQL database. All the processed complete fine, except for the confirming import (Full Import, Delta Sync) which repeatedly drops out with either a stopped-ma or stoppped-connectivity status. The detail of the error shows row-fetch-failure (0x80230805 or 0x80004005). the process typically falls over after only a few thousand records, but if I run it repeatedly, it seems to complete after half a dozen failures. I cannot find anything that seems relevant using Google or searching TechNet and would appreciate any pointers that might help me work out what is going wrong.

Full import is when you require a sustained connection to target SQL instance. Is it possible that these rows are in use by another application? You should be able to verify this with a SQL profiler trace performed at the time of full import.