We have setup SharePoint 2013 with SQL 2014. 2014 June CU is also installed.
Since my previous attempts failed, I tried to set up
user profile service using the farm account. It is a local admin account and given log on locally privilege. And made sysadmin in the SQL DB (an act of desperation).
I did not find PowerShell profiles created in any of the locations retired by running the script
"$PROFILE | Format-List -Force".
After creation of the proxy and the service application, when I try to start the service,
it either stops or stays stuck in "starting" stage.
I have a separate account to read the AD with the privileges. But to set up a connection I have to get the service running, so I can't enter that account.
Can somebody let me know what am I doing wrong and point me in the right direction?