The Forefront Identity Manager Synchronization Service service terminated with service-specific error %%-2146234334.

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

Also published on the TechNet Wiki as: The Forefront Identity Manager Synchronization Service service terminated with service-specific error %%-2146234334.