I installed sharepoint 2010 on a 2008 R2 server. I used SQL Express R2. The problem is that after I start the User Profile Synchronization Service in Sharepoint, I get the following event in the application log:
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event
<Data>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.</Data>
The other applications in Sharepoint seem to find the SQL server just fine. Is there supposed to be a "FIM Service" datatebase in SQl? If so, I don't have one.
How can I get the FIM service to connect to SQL?