This User Profile Application's connection is currently not available

1. Try to start the services before you start create the Service Applications.


This User Profile Application's connection is currently not available. The Application Pool or User Profile Service may not have been started. Please contact your administrator.
Resolution:
1. Application Pool  must have stopped, Restart it.
2. Try changing the Application pool Account in Inetmgr and change back to LocalService.
3. Check the Service if it started or not.


SQL Server Error while opening the Synchronization connections?
Resolution:
1. Configure Service Accounts and modify for the User Profile Service to a account which has access.


Useful:


https://www.nothingbutsharepoint.com/sites/devwiki/SP2010Admin/Pages/15%20-%20Configure%20User%20Profile%20Synchronization%20Service.aspx

Other Steps:
1. Restart the Application Pool (Sometimes WebRoot Pool gets stopped, restart it)
2. IISReset
3. Stop Start User Profile Service.
Note: UserProfSvc is just used in Connection String, evenywhere else, we use farmsvc