Share via

FIM/MIM: Installation using an SQL Server Alias

  • Article

Purpose

The purpose of this document is to provide an illustration of how to install Forefront Identity Manager 2010 (FIM 2010) where you need to install using a different SQL Server port.  We can accomplish this task by using a SQL Server Alias.

By default, FIM 2010 communicates to SQL Server using port 1433.  Often there is a desire to configure SQL Server to listen on a non-default port.

Solution

  1. Install the Full-Text Search feature for the SQL Server instance.

  2. Create a SQL Server Alias (http://msdn.microsoft.com/en-us/library/ms190445.aspx).

  3. Configure TCP parameter Port Number to be used by the alias to connect to SQL Server. (Here we used 1529)

  4. Restart the SQL Service

  5. Create a DNS record (A Record) for the alias and use IP Address of the SQL Server.

  6. From an administrative command prompt run :> ipconfig /flushdns

  7. From an administrative Command Prompt run the following:

    setspn -S MSSQLsvc/SQL2008Alias.contoso.com:1433 SVC_FIMSERVICE
setspn -S MSSQLsvc/SQL2008Alias:1433 SVC_FIMSERVICE

  8. When installing FIM, connect to the SQL database

  9. For Database Server use ALIAS\INSTANCE

     

See Also