Microsoft.ResourceManagement.Service: System.InvalidOperationException: The SQL Server Service Broker must be enabled on the Forefront Identity Manager Service database. Refer to the documentation of the SQL Server Service Broker, or the Transact-SQL ALTER DATABASE statement, for instructions on how to enable it.
or
at Microsoft.ResourceManagement.Data.DataAccess.ValidateConnectionString(String connectionString, Boolean validateBroker)
at Microsoft.ResourceManagement.Data.DatabaseConnection.InitializePrimaryStoreConnectionString()
at Microsoft.ResourceManagement.Data.DatabaseConnection.get_ConnectionString()
at Microsoft.ResourceManagement.Data.DatabaseConnection.Open(DataStore store)
at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction, IsolationLevel isolationLevel, DataStore dataStore)
at Microsoft.ResourceManagement.Data.TransactionAndConnectionScope..ctor(Boolean createTransaction)
at Microsoft.ResourceManagement.Data.DataAccess.GetDatabaseVersion(Int32& databaseVersion, String& databaseBinaryVersion)
at Microsoft.ResourceManagement.Service.PlatformBasics.CheckDatabaseVersion()
at Microsoft.ResourceManagement.Service.PlatformBasics.Initialize(Boolean isService)
at Microsoft.ResourceManagement.Service.Application.CreatePlatformBasics(Boolean initialize, Boolean isService)
at Microsoft.ResourceManagement.Service.Application.Start()
If the FIM Service is running, stop the service.
You can check active connections by running the following command:
select spid,hostname,loginame,cmd,db_name(dbid) as dbname, status
In the FIMService database, you can enable the SQL Server Service Broker using the following command from the SQL Server Management Studio:
ALTER DATABASE [FIMService] SET ENABLE_BROKER WITH NO_WAIT
2. use SQL Server Management Studio to set the option Broker Enabled to True.