User Profile Synchronization service in SharePoint Stuck Starting – HostId is not registered

ISSUE User Profile Synchronization service in SharePoint Stuck Starting. When reviewing the eventlog you notice the following error every 5 seconds ERROR Event ID 3, Source ForeFront Identity Manager,  .Net SqlClient Data Provider: System.Data.SqlClient.SqlException: HostId is not registered   at