FIM installation RRS feed

  • Question

  • Hi,

    I'm trying to install the FIM 2010  on windows server 2008 r2.

    I was following the guide and i'm now in the 7th step. 

    I'm stuck in the  Configure Forefront Identity Manager Synchronization Service page, when i click next , it gives me the following message:

    " Forefront identity manager synchronization service evaluation is having trouble contacting sql server using the provided information. Please note that Forefront identity manager synchronization service evaluation reqiurs microsoft sql server 2008 sp1 or better. verify the version, server and instance names as well as firew .. "

    I'm using microsoft sql server 2008 r2

    Wednesday, August 1, 2012 11:17 AM

All replies

  • This can also mean it can't connect to the server using the info you've given it. For example is there a named instance? If so you need to specify that too.

    Wednesday, August 1, 2012 11:24 AM
  • no there is no named instance, i m using the default one
    Wednesday, August 1, 2012 11:26 AM
  • Is your installation account SQL Server sysadmin?

    Wednesday, August 1, 2012 11:36 AM
  • I'm logging on the FIM server as the domain admin

    (Gaston, I didn't really understand your question )

    Wednesday, August 1, 2012 11:39 AM
  • Well, if you installed SQL Server with you domain admin, you propably are but otherwise you have to grant that right.

    "To be able to install FIM Synchronization Service or FIM Service, the account must be a SQL sysadmin. You do not have to be a sysadmin after the installation is complete."

    Wednesday, August 1, 2012 11:43 AM
  • I installed SQL server with the domain admin. But I will check again .
    Wednesday, August 1, 2012 11:55 AM
  • the domain admin is a sysadmin
    Wednesday, August 1, 2012 12:05 PM
  • You might also need the "SQL 2008 native client" on your FIM server. Not sure if lacking that would cause the error you have. But it will definately cause troubles when upgrading FIM.

    If you can't manage to get it right from within the configuration wizard of FIM, you might try to make it easier:

    * try creating an ODBC connection on the FIM server as a simple test. Does that work?

    Wednesday, August 1, 2012 1:43 PM
  • For the SQL native client , it's already in the FIM server, so it's not the source of the error. I will try the ODBC connection .
    Wednesday, August 1, 2012 1:49 PM
  • Is the SQL server local or remote?

    If remote you need to allow inbound connection for TCP 1433 in local firewall on the SQL server.

    Are you using SQL alias?

    If so i think you need to make sure you use the SQL client from the SQL server media not the standalone download (they differ for some reason)

    Wednesday, August 1, 2012 4:25 PM
  • ODBC doesn' work (error 10060) 

    The SQL server is remote, the inbound connection is allow for TCP 1433, tcp 455 and udp 1434 in local firewall of the SQL server.

    @Kent:  what's the difference between the standalone client and the one from the sql server media ?

    Thursday, August 2, 2012 11:15 AM
  • I'm using SQL express, is this a problem ?
    Thursday, August 2, 2012 1:32 PM
  • It is *the* problem -- FIM will not install on SQL Server Express.  Please review the server requirements here:
    Thursday, August 2, 2012 2:47 PM
  • Regarding the SQL client.

    As far as I know the difference is that the standalone download does not include the SQL WMI provider required in some cases (backup/restore) in SharePoint.

    Saturday, August 11, 2012 6:31 AM
  • You can goto the Local Security Policies of the computer and verify if the users is not part of any "Deny Access to this computer form the network" if it is then remove the users form the group.

    Thursday, July 11, 2013 10:15 AM