After configuring user profile you get the correlation id
and in event logs you get
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.
Open central administration à
security à
Configure Service Account (On the drop down pick Farm Account) and ensure that the select and account for the
component is the same as the one you are using to configure FIM (User profiles)
the OK.
That should fix that issue.
Happy FIMing