When installing FIM, do you ever get one of these: "Forefront Identity Manager Synchronization Service is having trouble contacting SQL server using the provided information. Please note that Forefront Identity Manager Synchronization Service requires Microsoft SQL Server 2008 SP1 or better. Verify the version, server and instance names as well as firewall settings and try again."
99 times out of 100, the issue turns outt hat you fat-fingered or simply have the server and instance names wrong. However, for that 1 time out of a 100, it can be frustrating to debug. I ran into the one of these times this morning and thought I'd put together a check list for the next I (or you) need it:
Hope this helps!
If you are using SQL 2012 make sure you are using FIM Identity Management 2010 R2 SP1 (R2 does not support SQL 2012)
7.Verify that the SQL Native Client is installed. did the trick for me.
Thanks for the info. My problem is because of the Native Client