[FIM-Troubleshooting] FIM Service Management Agent - Failed to connect to the specified database

[FIM-Troubleshooting] FIM Service Management Agent - Failed to connect to the specified database

Problem Statement
After following the conventional steps to troubleshoot the FIM Management Agent to retrieve the schema (http://social.technet.microsoft.com/wiki/contents/articles/10482.troubleshooting-fim-ma-failed-to-retrieve-schema-troubleshooter.aspx) none of the steps were able to resolve the issue.

Cause
The miiserver.exe.config file was either corrupted, or contained bad data.

Other Causes

  1. Version Mismatch: If the build version of the FIM Service and the build version of the FIM Synchronization Service are not at the same build, then you could receive the Failed to connect to specified database error message.

Resolution

In this particular case a few environments were set up with FIM for different purposes: FIM DEV for development environment and FIM PROD for production. The troubleshooting on the FIM PROD server pointed to problems with the miiserver.exe.config file. In this case we were able to take the config file from the working FIM DEV environment and copy it over to the FIM PROD server.

Once done we were then able to refresh the schema successfully on the FIM PROD Sync service manager.

ADDITIONAL INFORMATION

 

Leave a Comment
  • Please add 8 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Tim Macaulay edited Revision 1. Comment: updated the title, and added an additional cause, and updated tags

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
  • Tim Macaulay edited Revision 1. Comment: updated the title, and added an additional cause, and updated tags

Page 1 of 1 (1 items)