I was in the process of configuring aag on two new 2014 Enterprise servers. The configuration going good and the cluster, the nodes, the listener, the fileshare witness are online. Everything seems normal and I can failover from one node to another. However the second node showed not joining the aag. When I tried to join it using ssms, the following error is displayed.
What is in the SQL SERVER Error log stated as follows. "Database Mirroring login attempt by user '' failed with error: 'Connection handshake failed. The login '' does not have CONNECT permission on the endpoint."
I also search for an answer and based on what I got, I create a login MYDOMAINNAME\svc_sqlserver on both nodes and grant hadr_endpoint to it. When I tried again the issue is not resolved. It seems permission issue but I couldn't figure out it.