MIMFIMMA Creation: Failed to connect to the specified database or Forefront Identity Management Service

Are you having issues creating the MIM/FIM Portal Management Agent because you are getting an error like the one below?

After you have exhausted all the usual things (e.g. making sure it's not a firewall issue, making sure it's not a SQL login permission issue, etc.) but are still stumped, check the Forefront Identity Manager Management Agent event log (i.e. EventLog --> Applications and Service Logs --> Forefront Identity Manager Management Agent) and see if you are getting an error like the one below:

System: System.UriFormatException: Invalid URI: The format of the URI could not be determined.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
at MIIS.ManagementAgent.RavenMA.InitializeConnection(XmlNode connectionInformationNode, XmlNode encryptedAttributeNode, Boolean runInitialization)
at MIIS.ManagementAgent.RavenMA.UIInitialize(String pszInitString, Int32& pfValid, String& ppszResult)

 

If you are, then the answer is quite simple -- you can actually see it in the screen shot above if you aren't too distracted by the error message. If you can't see it, let me point it out to you in the screenshot below:

What you have done is neglected to put the FIM Service base address value in the http://<SPN>:5725 notation. Adjusting the value as depicted below will correct your mistake and allow you to proceed:

A groan-worthy, forehead slapping, bonehead mistake? Absolutely, but also a simple and easy one to make if you aren't paying attention, which is why I am putting this debugging tip up for others.