Deploying MIM 2016 - no MIMMA account was created in SQL and initial Create MA failes RRS feed

  • Question

  • I have followed TechNet Deploy MIM and have been successful with the initial build. I installed the MIM 2016 Synchronization Service , the MIM Service & Portal and attempted to Create the MIM MA for the FIM Management Service Agent.   I get errors "Failed to connect to the specified database".  The document states to use the contoso\MIMMA account I created at the beginning of the build along with other service accounts and groups.

    I checked the SQL 2014 Standard instance on the same server.  It only has two accounts provisioned for MIM (MIMService & MIMSync)

    What MIM accounts are required to have logins & roles in SQL?

    Is MIMMA the correct account to use for this function?

    Thanks, Stu

    Monday, August 31, 2015 2:07 PM

All replies

  • Was successful at using the Create MA wizard to connect to the database.  The TechNet documentation for MIM 2016 has what appears to be some errors.

    Removed the below local security policy. Both these accounts need to connect to the local SQL database.

      1. On the details pane, right click on Deny log on locally, and select Properties.

      2. Click Add User or Group, and in the User and group names, type contoso\MIMSync; contoso\MIMService and click OK

    Used the MIMSync account rather than the documented MIMMA account.  MIMMA does not have a SQL login defined. Only MIMSync & MIMService are provisioned by setup in SQL.

    Monday, August 31, 2015 3:48 PM