Always on High availability

Question

Hi, I am creating Always on high availability group and stuck at error [failed to join the database 'DB10" to the availability group 'G10' on the availability replica 'SQLDEV17-02\SQLSERVER02'] , i can see [the connection to the primary replica is not active error: 35250]. When i check logs i found below

2019-03-13 22:56:46.57 Logon Error: 18456, Severity: 14, State: 5.
2019-03-13 22:56:46.57 Logon Login failed for user 'RESEMBLECORP\SQLDEV17-01$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
Here RESEMBLECORP is domain and SQLDEV17-01$ is server. i am not getting why it is taking machine account instead of taking service account 'RESEMBLECORP\administrator'.

hari_9396 · Answer

yavuzfilizlibayyes it has, but not working before. Now it is working fine after reinstalling the setup.

yavuzfilizlibay · Answer

Hari_9396&nbsp;RESEMBLECORP\administrator have sql sysadmin role?

Forum Discussion

Always on High availability

Share