[Troubleshooting]: FIM Service Management Agent: Failed to retreive schema or Cannot connect to database when creating the FIM Service Management Agent

Hello.

As we continue to compile information pertaining to problems either connecting to the backend FIM Service Database, or Retrieving the Schema during the creation of the FIM Service Management Agent and/or modifying the FIM Service Management Agent.  The below Microsoft TechNet Wiki Articles that we in support have written.  Please let us know if the information is useful, beneficial, helps you resolve your issue. 

• Troubleshooting: FIM MA - Failed to retreive schema Troubleshooter: http://social.technet.microsoft.com/wiki/contents/articles/10482.troubleshooting-fim-ma-failed-to-retrieve-schema.aspx
• Troubleshooting: failed to retrieve schema or cannot conect to database when creating FIM MA: http://social.technet.microsoft.com/wiki/contents/articles/9112.troubleshooting-failed-to-retrieve-schema-or-cannot-connect-to-database-while-creating-a-fim-ma.aspx
• Troubleshooting: FIM Service Management Agent - Failed to connect to the specified database: http://social.technet.microsoft.com/wiki/contents/articles/16980.troubleshooting-fim-service-management-agent-failed-to-connect-to-the-specified-database.aspx
• Troubleshooting: Failed to connect to specified database.  The extension operation aborted due to an internal error in FIM Synchronization Service: http://social.technet.microsoft.com/wiki/contents/articles/17367.troubleshooting-failed-to-connect-to-specified-database-the-extension-operation-aborted-due-to-an-internal-error-in-fim-synchronization-service.aspx