Hi Experts, Please see if you can help...
Im trying to setup userprofile synchronization services on sharepoint 2010 (end requirement is to have all AD profile informations on sharepoint )
When attempting to start the userprofile synchronization service in sharepoint 2010
(Procedure followed as per http://www.harbar.net/articles/sp2010ups.aspx
, the status of the service remains at "starting" and at the same time , FIM (forefront identuty manager) service gives the following error...
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.
Looks like a permission issue, but all permissions prerequisits are met, like
farm account have local admin and logon locally rights. the userprofileservice application uses the farm acocunt itself and farm account has admin rights and full permission on this userprofile service application. the farm account also has database ownership on DBs like Profile DB, sync DB, social DB etc created by the userprofileServiceApplicat
I tried clearing the timer config files also.
I also verified that security token service has only windows and anonymous auth enabled
What else can be tried to resolve this issue and achive userprofile synchronization between my AD and Sharepoint 2010?