locked
Unable to Install MIM 2016 SyncServices RRS feed

  • Question

  • Hi,

    When installing MIM Synchronization Service I keep getting this error:

    Product: Microsoft Identity Manager Synchronization Service -- Error 25009.The Microsoft Identity Manager Synchronization Service setup wizard cannot configure the specified database. <hr=0x80131700>

    - Setup-User is admin on MIM Server and SA on remote SQL Instance. Any Idea?
    - It's a new MIM Installation & SQL native Client is installed
    - The definied SA has no SQL Login and the DB does not exist on the SQL Instance

    best regards

    Pirmin

    Friday, September 4, 2015 8:21 AM

Answers

  • Thanks for your feedback.

    You're right. I *should* have read the pre-reqs more carefully. It was no SQL issue. I just missed to install .Net 3.5 on the MIM Server.

    Here some additional comments regarding permissions - because I did some testing on that:
    I use a setup user to setup MIM Synchronization Server. That user needs local Admin rights on the MIM Server. Moreover it needs the dbcreator & securityadmin role on the SQL Instance to be able to create FIMSynchronizationService database and create a SQL login for the MIM Synchronization Service-account. Because setup creates the db & sqlLogin, the serviceAccount Login & database must NOT exist on SQL Instance prior the MIM Setup. SQL permission delegation to MIM Serviceaccount is automatically done trough the setup process.

    To summarize:
    - Install Windows Server 2012 R2
    - Install .Net Framework 3.5
    - Install SQL Native Client 11.xx
    - Delegate dbCreator & securityAdmin on SQL to the user which setups MIM Sync.
    - Run SynchServer Setup with that user (which has Admin rights on MIM Server) & be happy.

    regards

    Pirmin

    • Marked as answer by Pirmin Felber Sunday, September 6, 2015 12:18 PM
    Sunday, September 6, 2015 12:18 PM

All replies

  • Setup-User is admin on MIM Server and SA on remote SQL Instance. Any Idea?  NO IDEA What this means.
     The definied SA has no SQL Login and the DB does not exist on the SQL Instance. No Idea what this means either

    -----------------------------------------------------

    Do the following.

    1. Service accounts used by FIM Sync and FIM Portal (MIM Same thing) need to be SYSADMIN in SQL Server where the product is being installed.

    2. SQL Server Full Text Index option needs to be installed in the SQL Server

    ----------------------------------------------------------

    It is a good practice to read carefully the pre-reqs before trying to install this product. 


    Nosh Mernacaj, Identity Management Specialist

    Friday, September 4, 2015 1:28 PM
  • Thanks for your feedback.

    You're right. I *should* have read the pre-reqs more carefully. It was no SQL issue. I just missed to install .Net 3.5 on the MIM Server.

    Here some additional comments regarding permissions - because I did some testing on that:
    I use a setup user to setup MIM Synchronization Server. That user needs local Admin rights on the MIM Server. Moreover it needs the dbcreator & securityadmin role on the SQL Instance to be able to create FIMSynchronizationService database and create a SQL login for the MIM Synchronization Service-account. Because setup creates the db & sqlLogin, the serviceAccount Login & database must NOT exist on SQL Instance prior the MIM Setup. SQL permission delegation to MIM Serviceaccount is automatically done trough the setup process.

    To summarize:
    - Install Windows Server 2012 R2
    - Install .Net Framework 3.5
    - Install SQL Native Client 11.xx
    - Delegate dbCreator & securityAdmin on SQL to the user which setups MIM Sync.
    - Run SynchServer Setup with that user (which has Admin rights on MIM Server) & be happy.

    regards

    Pirmin

    • Marked as answer by Pirmin Felber Sunday, September 6, 2015 12:18 PM
    Sunday, September 6, 2015 12:18 PM
  • Hi guys, I'm running the same setup but SQL 2008 R2 SP3 and I'm still getting the following error.

    Does the SQL 2008 R2 SP3 server supports that I install SQL Native Client 11.xx at mim sync server in order to connect there?

    regards,


    Thiago Beier Se foi &#250;til marca como resposta! Don&#180;t forget to mark as answer!

    Wednesday, April 6, 2016 1:29 PM
  • Yes, you need to install SQL Native Client (sqlncli.msi) on the MIM/FIM server if SQL is remote.
    • Proposed as answer by Rick Eveleigh Tuesday, August 30, 2016 10:22 AM
    Tuesday, August 30, 2016 10:22 AM
  • I am getting this issue with SQL Server 2014 version 12.0.5000 installed on Server 2016.

    I have 

    Server 2016  + SQL native client 11 + .net 4.5 , 3.5

    when I try to install MIM 2016 synchronization service sp1  

    I get the above error : 

    having trouble with contacting SQL server using the provided information.............................

    Saturday, April 29, 2017 3:30 AM
  • You need SP1 on SQL 2014

    Nosh Mernacaj, Identity Management Specialist

    Saturday, April 29, 2017 11:37 AM