Always on High availability

%3CLINGO-SUB%20id%3D%22lingo-sub-369281%22%20slang%3D%22en-US%22%3EAlways%20on%20High%20availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369281%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20creating%20Always%20on%20high%20availability%20group%20and%20stuck%20at%20error%20%5Bfailed%20to%20join%20the%20database%20'DB10%22%20to%20the%20availability%20group%20'G10'%20on%20the%20availability%20replica%20'SQLDEV17-02%5CSQLSERVER02'%5D%20%2C%20i%20can%20see%20%5Bthe%20connection%20to%20the%20primary%20replica%20is%20not%20active%20error%3A%2035250%5D.%20When%20i%20check%20logs%20i%20found%20below%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E2019-03-13%2022%3A56%3A46.57%20Logon%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Error%3A%2018456%2C%20Severity%3A%2014%2C%20State%3A%205.%3CBR%20%2F%3E2019-03-13%2022%3A56%3A46.57%20Logon%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Login%20failed%20for%20user%20'RESEMBLECORP%5CSQLDEV17-01%24'.%20Reason%3A%20Could%20not%20find%20a%20login%20matching%20the%20name%20provided.%20%5BCLIENT%3A%20%3CLOCAL%20machine%3D%22%22%3E%5D%3CBR%20%2F%3E%3C%2FLOCAL%3E%3C%2FFONT%3EHere%26nbsp%3B%3CFONT%3ERESEMBLECORP%3C%2FFONT%3E%20is%20domain%20and%26nbsp%3B%3CFONT%3ESQLDEV17-01%24%3C%2FFONT%3E%20is%20server.%20i%20am%20not%20getting%20why%20it%20is%20taking%20machine%20account%20instead%20of%20taking%20service%20account%26nbsp%3B%3CFONT%3E'RESEMBLECORP%5Cadministrator'.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalysis%20Services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIntegration%20Services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReporting%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389296%22%20slang%3D%22en-US%22%3ERe%3A%20Always%20on%20High%20availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389296%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308568%22%20target%3D%22_blank%22%3E%40yavuzfilizlibay%3C%2FA%3Eyes%20it%20has%2C%20but%20not%20working%20before.%20Now%20it%20is%20working%20fine%20after%20reinstalling%20the%20setup.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389102%22%20slang%3D%22en-US%22%3ERe%3A%20Always%20on%20High%20availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F300660%22%20target%3D%22_blank%22%3E%40Hari_9396%3C%2FA%3E%26nbsp%3B%3CSPAN%3ERESEMBLECORP%5Cadministrator%20have%20sql%20sysadmin%20role%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.