top of page

Not able to add Second Server in SQL 2014 Availability Group

When I am trying to add the Second Server for the SQL AlwaysON Group, I end up with following error


2

After Serious Search in Internet, Found the solution which resolved the above issue

After Serious Search in Internet, Found the solution

Run the Below Command in Primary Server,

Here windowstechpro\SFBDB2$ is Domain\SecondNode$

use [master]

GO

CREATE LOGIN [windowstechpro\SFBDB2$] FROM WINDOWS

GO

GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [windowstechpro\SFBDB2$]

GO

Run the Below Command in Second Server,

Here windowstechpro\SFBDB1$ is Domain\PrimaryNode$

use [master]

GO

CREATE LOGIN [windowstechpro\SFBDB1$] FROM WINDOWS

GO

GRANT CONNECT ON ENDPOINT::[Hadr_endpoint] TO [windowstechpro\SFBDB1$]

GO

Then tried to add the Second Node again and found I am able to add it without any other issues.

4 views0 comments

Comentarios


bottom of page