Moving the FIM 2010 R2 (FIM Service, read FIM portal) to a new SQL server

Shutdown the Forefront Identity Manager Service in services.cpl.

Backup the DB from the SQL Manager

Move it, rename it, restore it.

On the new DB server, set the FIM service account you are using as DB_Owner

 

You need to run the following command to enable SQL server service broker for the FIM Service Database since the DB has been restored. Remember that every time you restore FIM Service from a backup or move the DB to a new server, you would need to:

ALTER DATABASE [SQLD0040Q] SET ENABLE_BROKER WITH NO_WAIT

The alter query may fail if there are active connections to the database. You need to fix that if so.

 

On the FIM portal server

Open RegEdit
    Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\FIMService

DatabaseServer is the name of the new SQL Server (it would have been blank if the local server was the SQL server)

DatabaseName is the file name in the remote SQL Server

 

Start the FIM Services