Troubleshooting FIM: Server Database could not be successfully deployed.

Problem Statement

Installing the FIM Service and Portal an error message may appear with the wording below:

“The Forefront Identity Manager Server database could not be successfully deployed.  Error: Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.”

Cause

The initial size set for the database on the Model Database is large, so any new database created will use the Model Database as a template to create a database.  This caused the timeout when installing the FIM Service and Portal.

Resolution:

Once the Model Database size was reduced we were able to install the FIM Service and Portal

*NOTE: The Model Database is a SQL Server System Database.  It is what SQL Server utilizes to create a database initially.

Here is a snapshot of the default Model Database Settings inside of SQL Server 2008 R2.

Additional Information:

• Model Database: http://msdn.microsoft.com/en-us/library/ms186388.aspx