Table of Contents


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.


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

2. Create a SQL Server Alias (

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/ 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