Support-Info: (DATABASE): What SQL Server is hosting my FIM/MIM database

  • Article

The purpose of this blog is to provide the registry keys that identify where the FIM/MIM Databases are located.  The complicated one is going to be the SharePoint 2010, 2013 User Profile Sync Service, as that one is compiled into a DLL that hosts that information.

Here are the registry keys:

FIM SERVICE DATABASES
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FIMService
APPLIES TO:
  • Forefront Identity Manager 2010 / R2 / R2 SP1
  • Microsoft Identity Manager 2016 / SP1
 

 

FIM SYNCHRONIZATION SERVICE DATABASE
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FIMSynchronizationService\Parameters
  • SERVER PROPERTY: Specifies the name of the SQL Server, SQL Server Cluster, SQL Server Alias
  • SQLINSTANCE PROPERTY: Specifies the name of the instance
APPLIES TO:
  • Forefront Identity Manager 2010 / R2 / R2 SP1
  • Microsoft Identity Manager 2016 / SP1
If you are looking to move the backend database for the FIM Synchronization Service Database, check out this Microsoft TechNet Wiki.  https://social.technet.microsoft.com/wiki/contents/articles/5465.fimilm-how-to-move-the-backend-sql-server-synchronization-service-database.aspx

 

SHAREPOINT FOUNDATION SERVER 2013: CONFIGURATION DATABASES
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDBHere is some information on moving these backend databases: https://blogs.technet.microsoft.com/meamcs/2014/06/10/moving-sharepoint-databases-to-another-server-without-reconfiguring-sharepoint/

 

AZURE AD CONNECT SYNC
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ADSync\Parameters
APPLIES TO:
  • Azure AD Connect Sync
 

Additional Information / Resources