Share via

MIM/FIM Troubleshooting: Sync service terminated with service-specific error %%-2146234334 (SQL)

  • Article

 

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

SQL Connection - Restart SQL Service

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.

FIM Sync service - Set Delayed Start

During startup, The FIM/MIM Sync service might try to connect to the SQL service which is starting.

Setting the FIM/MIM Sync service in "Delayed Start", will fix this problem.

See Also