Applies to:

SharePoint server 2010, Windows Server 2008, Fore front Identity manager.

Issue

 FIM synchronization services in our one of the SharePoint environment stops or doesn’t start every time our servers are patched and rebooted.

 

Error

 We have many loges reported in event viewer of the servers. Event ID 3, Event ID 6324, Event ID 3760

EventID 3

Log Name:      Application

Source:        Forefront Identity Manager

Date:          29/06/2014 03:16:04

Event ID:      3

Task Category: None

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      Server Name.

Description:

The TryGetSetting function in SettingsProvider.dll returned an empty set of supported parameters for property, SQLConnectionString.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="Forefront Identity Manager" />

    <EventID Qualifiers="0">3</EventID>

    <Level>2</Level>

    <Task>0</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2014-06-29T02:16:04.000000000Z" />

    <EventRecordID>1469029</EventRecordID>

    <Channel>Application</Channel>

    <Computer> Server Name</Computer>

    <Security />

  </System>

  <EventData>

    <Data>The TryGetSetting function in SettingsProvider.dll returned an empty set of supported parameters for property, SQLConnectionString.</Data>

  </EventData>

</Event>

EventID 6324

Log Name:      Application

Source:        FIMSynchronizationService

Date:          29/06/2014 03:18:05

Event ID:      6324

Task Category: Server

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      Server Name.

Description:

The server encountered an unexpected error and stopped.

EventID 3760

Log Name:      Application

Source:        Microsoft-SharePoint Products-SharePoint Foundation

Date:          29/06/2014 03:18:38

Event ID:      3760

Task Category: Database

Level:         Critical

Keywords:     

User:          Farm account.

Computer:      Server Name.

Description:

SQL Database ‘DB Name; on SQL Server instance ‘SQL Server Instances Name,14331' not found. Additional error information from SQL Server is included below.

Cannot open database "DB Name" requested by the login. The login failed.

Login failed for user ‘Farm account name’.

  

Troubleshooting

 

There are different approaches towards troubleshooting this issue as reason for its occurrence is unknown.

 

Resolution:

 

Different people had suggested different things:

 

First

Such as adding service account into three groups on local machine:

FIMSyncOperator, FIMSyncJoiners and FIMSyncBrowse and errors should go.

But this is essentialy not required for the service to run. These groups essentially do not have the power required to manage FIM.

 

Second

FIM Sync service should start before FIM service. However it may not be happening. Currently the service is set to Automatic and can be changed to Automatic (Delayed Start).

WWe could deploy a script which will check for the service every 60 seconds, and if it is not running, sends an email to the administrator

  • while ((Get-Service "FIM").status -eq "Running")
  • {Start-Sleep -Seconds 60}
  • Send-MailMessage -From FIM@ps.local -To admin@ps.local -Body "FIM Stopped" -SmtpServer server1

Alternatively, you can put a .cmd file in your Recovery Tab of the service,  and use the following command: Powershell Send-MailMessage

 

Third

In our case we had also found there were several SQL related error and in further investigation we found that server hosting FIM service were rebooted before the SQL server and once the SQL servers were re-booted FIM services always failed to find it reference to connect to SQL.

Rebooting SQL servers after server hosting FIM services had let FIM sync Services in Start state and resolved our issue.

Credits

Read at my Blog: http://mossnwss.blogspot.in/2014/10/forefront-identity-manager-stops-after.html