Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (bMicrosof)
  • When: 30 Nov 2012 2:14 PM
  • Last revision by (fMicrosof)
  • When: 4 Dec 2012 2:43 PM
  • Revisions: 6
  • Comments: 1
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  How to install FIM using a SQL Server Alias

How to install FIM using a SQL Server Alias

How to install FIM using a SQL Server Alias

Table of Contents

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

, , , , , , [Edit tags]
Leave a Comment
  • Please add 4 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 4 Dec 2012 2:43 PM

    Peter Geelen - MSFT edited Revision 4. Comment: consolidated layout

Page 1 of 1 (1 items)