0
Answered

FIM agent test is failing

Meni Ariely (European Patent O 7 years ago • updated by anonymous 3 years ago 3

After installing Event Broker on Production, the FIM agent is failing with the following error message:
The test of Agent FIM (238a0962-e8f2-41c6-acb0-4bcf7fa2ff1f) failed with message:
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "FIMSynchronizationService" requested by the login. The login failed.
Login failed for user 'INTERNAL\FIMAdminUser'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Unify.Product.EventBroker.FIMAgent.TestConnection()
at Unify.Product.EventBroker.AgentEngine.Notify(ITestAgentConnectionMessage message)

Have already compared the installation to the Integration env.(which works) and could not find what might be the reason it's not working on Productions.

I would appreciate any advice.

Regards,

Meni Ariely

Hi Meni,

Is the target SQL Server instance on a different server to the Integration environment?
Have you confirmed that the account has permission on this SQL Server instance? Keeping in mind that whilst using the Authentication Type of Windows, the account will be the same as the service account. Whereas an Authentication Type of SQL will use SQL Server Authentication (which is not a Windows account).

Thanks.

Problem is solved now. Giving the account correct access to the SQL DB allowd FIM agent to start correctly. Thanks for your support.
Meni Ariely