Are there any suggestions/recommendations/instructions on how to move the FIM database from local to remote when FIM has been installed already? Thanks.

YWanda, First off, I haven't executed the procedure I'll mention below. So it might not be accurate, or don't work. But I do hope you will be performing this in a test environment first. What I would do: Have a backup of your SQL databases Make sure no run profiles will execute during the move (scheduled tasks etc) Stop the FIM Service Put the DB offline in SQL Start the MSI you used to install the FIM Service => choose for change/reconfigure Create a new FIM Service DB on this new SQL server, use the same database name. Leave all other options as they were from the original install Stop the FIM Service again Detach the newly created database on the new SQL server Copy the old database over to the new SQL server Attach the database again Start the FIM Service again The above is completely to be tested by you and is how I would try it in a lab environment. I'm not completely sure with step 3 and 4. 3 might not be necessary and 4 might also come after 7. It would be nice if you could give some feedback if the above actually works. Good luck, Thomas http://setspn.blogspot.com

Hi Thomas, Thanks for your reply. I did your steps for different domain of FIM and SQL database. It didn’t work. For one thing, I found it necessary to uninstall FIM because it does not allow reconfiguring to a remote location. I also want to add that the FIM DB I'm moving was converted from ILM to FIM several months ago and has been running fine in FIM. So I created a SQL 2008 R2 in the same domain with FIM. 1. Stop the FIM Service; 2. Put the DB offline in SQL 2008 R2; 3. Start the MSI you used to install the FIM service => choose for remove ( not change/reconfigure because this can’t change the DB location ) 4. Create a new FIM Service DB on this new SQL server, use the same database name. Leave all other options as they were from the original install; 5. Stop the FIM Service again; 6. Detach the newly created database pm the mew SQL server; 7. Copy the old database which was converted from ILM to FIM using Local SQL 2008 R2 database over to the new SQL 2008 R2 server; 8. Attach the database again; 9. Start the FIM Service again, the FIM would not start up and gave me error “The service was unable to start because the version of the database is newer than the version of the binaries installed. In order to enable the server to function normally, install the latest update.” 10. I have verified that on the FIM Synch Service system and on the remote SQL server engine both have the SQL 2008 R2 installed with version numbers "Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)" I also tried another way of trying to get this to work. A) I copied the DB to the remote SQL server and attached it. B) I then installed FIM and told it to point to the remote server. C) It complained that it could not do that because FIM was already installed. I tried many times using above steps and also tried to upgrade from ILM to FIM steps. None of them worked for me. I really appreciated any advice from you or other person.

Hi Thomas, Thanks for your reply. I did your steps for different domain of FIM and SQL database. It didn’t work. For one thing, I found it necessary to uninstall FIM because it does not allow reconfiguring to a remote location. I also want to add that the FIM DB I'm moving was converted from ILM to FIM several months ago and has been running fine in FIM. So I created a SQL 2008 R2 in the same domain with FIM. 1. Stop the FIM Service; 2. Put the DB offline in SQL 2008 R2; 3. Start the MSI you used to install the FIM service => choose for remove ( not change/reconfigure because this can’t change the DB location ) 4. Create a new FIM Service DB on this new SQL server, use the same database name. Leave all other options as they were from the original install; 5. Stop the FIM Service again; 6. Detach the newly created database pm the mew SQL server; 7. Copy the old database which was converted from ILM to FIM using Local SQL 2008 R2 database over to the new SQL 2008 R2 server; 8. Attach the database again; 9. Start the FIM Service again, the FIM would not start up and gave me error “The service was unable to start because the version of the database is newer than the version of the binaries installed. In order to enable the server to function normally, install the latest update.” 10. I have verified that on the FIM Synch Service system and on the remote SQL server engine both have the SQL 2008 R2 installed with version numbers "Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)" I also tried another way of trying to get this to work. A) I copied the DB to the remote SQL server and attached it. B) I then installed FIM and told it to point to the remote server. C) It complained that it could not do that because FIM was already installed. I tried many times using above steps and also tried to upgrade from ILM to FIM steps. None of them worked for me. I really appreciated any advice from you or other person.