Forefront identity manager service status is showing as blank in services console but I'm able to successfully start User profile service and User Profile Synchronization Service. But I couldn't synchronize SharePoint with AD because of this issue. This is the first time i'm facing such a weird issue.
I tried the following...
1 Restarted FIMS Server
2) Restarted SharePoint Server
3) Restarted UPS and UP Sync Service
I checked the event viewer and noticed the following error related to Forefront Identity Manager Service.
The Forefront Identity Manager Service cannot connect to the SQL Database Server.
The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly.
Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, verify the connection information has been configured properly. This configuration is stored in the Windows Registry.