none
R2 Sync service install connecting to remote SQL RRS feed

  • Question

  • We are currently attempting to install FIM2010R2 in our environment and are running into issues right away.  When attempting the install for FIM sync on a clean Windows 2008 R2 system we cannot get it to connect to a remote SQL server/instance.  We've attempted to connect to a SQL 2008 R2 cluster and a SQL 2012 Cluster however receive the same error.

    We have verified versions, server names instances and firewall settings.  We've verified SPN's for the sql service accounts, added the FIM Sync account as SQL sysadmin, and local administrator groups.  We can create ODBC connections, SQL alias and connect using SQL Management Studio from the server.  Just cannot get the install to connect.

    Any help would be appreciated.

    Friday, July 6, 2012 3:21 PM

Answers

  • Answer : SQL 2008 Native Client.  I guess the installer wants v10 not v11 of the drivers.

    http://www.microsoft.com/en-us/download/details.aspx?id=16978

    • Marked as answer by Pr0t0luke Friday, July 6, 2012 5:19 PM
    Friday, July 6, 2012 5:19 PM

All replies

  • Are you using a named instance of SQL?  I seem to remember a need to alias named instances--can dig up the details if so...

    Is there anything in the Application event log?

    You can also install with verbose logging, although I've never needed to do it for FIM (just have a look at msiexec /l).

    You do not need to add special permissions for the FIMSync service account; database creation, permissioning, schema updates, etc., all happen through the context of the logged-in user kicking off the installation.

    Friday, July 6, 2012 3:48 PM
    1. This is not a named instance, though I've tried both.
    2. There s nothing in the application log.
    3. Let me look into verbose logging, totally forgot to even try.
    4. Thanks!
    Friday, July 6, 2012 3:51 PM
  • Although you probably already have it if you've connected with SSMS, the SQL Native Client should be installed.  And, it wouldn't hurt to verify @@version to be safe.
    Friday, July 6, 2012 3:57 PM
  • Yep, native client is installed.  Both SSMS and client are v11 (SQL 2012 CU1).

    Verbose install did not yield helpful information.

    Action 12:36:39: SetStoreServerName.
    Action start 12:36:39: SetStoreServerName.
    Action ended 12:36:39: SetStoreServerName. Return value 1.
    Action 12:36:39: SetSQLServerInstanceEmpty.
    Action start 12:36:39: SetSQLServerInstanceEmpty.
    Action ended 12:36:39: SetSQLServerInstanceEmpty. Return value 1.
    Action 12:36:39: SetMSSQLSERVERServiceEmpty.
    Action start 12:36:39: SetMSSQLSERVERServiceEmpty.
    Action ended 12:36:39: SetMSSQLSERVERServiceEmpty. Return value 1.
    Action 12:36:39: CheckSQLInstallationWithoutMsg.
    Action start 12:36:39: CheckSQLInstallationWithoutMsg.
    Action ended 12:36:39: CheckSQLInstallationWithoutMsg. Return value 1.
    Action 12:36:39: SetupErrorSQLServerInfo. Dialog created

    Friday, July 6, 2012 4:38 PM
  • Answer : SQL 2008 Native Client.  I guess the installer wants v10 not v11 of the drivers.

    http://www.microsoft.com/en-us/download/details.aspx?id=16978

    • Marked as answer by Pr0t0luke Friday, July 6, 2012 5:19 PM
    Friday, July 6, 2012 5:19 PM
  • Thank you for this post!  I ran into this problem (same pop-up as above stating that SQL Server 2008 SP1 or better was required) while installing FIM 2010 R2 Sync Service with a Local instance of SQL Server 2012.  Installing the 2008 R2 Native Client allowed the installation to continue and was successful.  THANK YOU!

    Monday, October 29, 2012 8:50 PM