I'm getting the following error when starting the SIMSynchronizationServer: Log Name: Application Source: FIMSynchronizationService Date: 8/31/2010 6:30:36 PM Event ID: 6211 Task Category: Database Level: Error Keywords: Classic User: N/A Computer: W2008R2-4.vcctest.ca Description: The service was unable to start because the version of the database does not match the version of the product. Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="FIMSynchronizationService" /> <EventID Qualifiers="49152">6211</EventID> <Level>2</Level> <Task>2</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2010-09-01T01:30:36.000000000Z" /> <EventRecordID>9200</EventRecordID> <Channel>Application</Channel> <Computer>W2008R2-4.vcctest.ca</Computer> <Security /> </System> <EventData> </EventData> </Event> And when starting the FIMService: Log Name: Forefront Identity Manager Source: Microsoft.ResourceManagement Date: 8/31/2010 6:10:54 PM Event ID: 3 Task Category: None Level: Error Keywords: Classic User: N/A Computer: W2008R2-4.vcctest.ca Description: The database version is incorrect, expected version is 6 Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="Microsoft.ResourceManagement" /> <EventID Qualifiers="0">3</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2010-09-01T01:10:54.000000000Z" /> <EventRecordID>194941</EventRecordID> <Channel>Forefront Identity Manager</Channel> <Computer>W2008R2-4.vcctest.ca</Computer> <Security /> </System> <EventData> <Data>The database version is incorrect, expected version is 6</Data> </EventData> </Event> Does anyone know what this means? What lead to the problem was the SQL server ran out of space. When the administrator went to log onto the server with a domain admin account they couldn't due to trust issues. They removed the server from the domain and rejoined it. When the server was rebooted 16GB of free space was recovered. This is a Pilot environment so it's not critical. Just want to get it runnning again.

The errors indicate that the versions of the DB don't match the binaries that are supposed to be matched with them, the sync service and FIM service. By any chance, were the SQL DBs restored from backup? What could have happened is that the version of the product was at update 1, 4.0.3531.2, the DBs would have been upgraded at same time. However, if the DBs were restored using copies that were from RTM version, 4.0.2592, I would expect a similar error. I would verify this using file versions. Specifically, check miiserver.exe and Microsoft.ResourceManagement.exe. Also, these need to be at the same version as each other for FIM to work properly.

I just checked the versions of miiserver.exe and Microsoft.ResourceManagement.Service.exe (I'm assuming you meant this file) and they are both 4.0.2592.0. The SQL DBs were never restored. Is there away in SQL to determine the correct version? I noticed you mentioned an Update 1. Is this update being provided thru Windows Update? Don't see it there or do you have to download the individual packages? Thanks Glenn

Bruce, Update 1 is available through Windows Update, yes. In SQL, check the version of the sync DB by going to the 'mms_server_configuration' table and checking the 'fixed_schema_version_number' number. On the FIM Service DB, there is a table called fim.version, what is the number in the 'Version' column?

The fixed_schema_version_number in the 'mms_server_configuration' table is 303. The version number in the 'fim.version' table is 2. Strange, the updates aren't showing up through the windows update.

Glenn, I just check my production 'fim.version' table number and it is 6. Not sure how the pilot/test one got changed to 2. What would happen if I changed the pilot/test environment to 6? Ad if one was to do this, not being a SQL expert, what's the easiest way to do it?

I don't know how that could have changed other than with being updated from the install program from one of the patches. You can edit the value from 2 to 6 directly and from 303 to 305(that is what my RTM install shows for Sync DB); of course, before you do this, I would make full backup of both DBs. After changing these values, I would expect services to start as expected.

When you say 'You can edit the value from 2 to 6 directly', do you mean by a SQL command? or is there a place in the GUI to do the change. I'm not a SQL expert so I'm not 100% how to make the change. Sorry for the ignorance here.

You can right click on table in SQL Management Studio and click 'Edit top 200 rows', this will allow you to manually change the value.

Thanks Glenn. I found it earlier 'Edit top 200 rows' this morning. Thanks for all your help. I was able to update the versions but I'm still having some issues. Doesn't look like I'm going to be able to resurrect FIM as I'm not sure what state the system is in. I think it's going to be better if I rebuild. Again, thanks.

Hi, where can I find this FIM Service DB ?? Thanks, J

Jaco, Directly editting the database is highly unrecommended. Perhaps you can start a new topic and explain your situation/problem? Regards, Thomashttp://setspn.blogspot.com

I realize this is an older closed thread but I kept coming across it over and over trying to fix the same problem. Since the solution accepted here doesn't really give the details as to what versions to enter in SQL and due to the reasoning we shouldn't be editing the DB I wanted to post up what I found as the solution that worked for me on 3 different farms with the same issue.. Hopefully it can help others with the same issue from searching for hours like I did instead of running a couple simple steps. Comes from this other thread that was answered by Tim Schaffler http://social.technet.microsoft.com/Forums/en-IE/sharepoint2010setup/thread/f89ac154-4e58-403c-b276-a2a07a39f40b Steps: Central Admin>System Settings>Manage Services on Server (select the server where the User Profile Service is running) Stop the User Profile Service Stop the User Profile Synchronization Service (you will be prompted that this will deprovision the service) Once the services have stopped, Start the User Profile Service again Start the User Profile Synchronization Service again (you will be prompted to enter the password for the User Profile Service's svc account) -note1: this service can take a little while to restart; note2: if it does not restart successfully, restart the server and try again (this has worked for me) Once complete, the User Profile Service and User Profile Synchronization service should show as Started, and the 2 corresponding FIM services on the server should be running again

Am unable to start the FIM service on my second node (Portal and service, Wss.3.0 standalone)am getting event ID 1503 ,source "User profile service" Please suggest