Always on High availability

Copper Contributor

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'.

 

2 Replies

@Hari_9396 RESEMBLECORP\administrator have sql sysadmin role?

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