Symptoms:

Error message:

Log Name:      System
Source:        Service Control Manager
Date:          7/29/2013 10:58:10 AM
Event ID:      7024
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      FIMServer.domain.test
Description:
The Forefront Identity Manager Synchronization Service service terminated with service-specific error %%-2146234334.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7024</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8080000000000000</Keywords>
<TimeCreated SystemTime="2013-07-29T08:58:10.790235400Z" />
<EventRecordID>18628</EventRecordID>
<Correlation />
<Execution ProcessID="612" ThreadID="3756" />
<Channel>System</Channel>
<Computer>FIMServer.domain.test</Computer>
<Security />
</System>
<EventData>
<Data Name="param1">Forefront Identity Manager Synchronization Service</Data>
<Data Name="param2">%%-2146234334</Data>
</EventData>
</Event>

Solution

Check the SQL DB connection to which the FIM Sync service is connecting to.
In this case the SQL services were stopped on the remote SQL server.