June 8, 2020 at 11:37 am
I've been trying to setup AlwaysON AG on two standalone default sql instances (SQL 2017 Enterprise Edition - 14.0.1000.169).
I've checked, port numbers (1433 and 5022) on both the servers are open and there's no issue with DNS. (Hostname is not more than 15 characters.)
Can anyone help me with this error please.
Msg 47106, Level 16, State 3, Server ''
Cannot join availability group ''. Download configuration timeout. Please check primary configuration, network connectivity and firewall setup, then retry the operation.
Msg 41158, Level 16, State 3, Server ''
Failed to join local availability replica to availability group ''. The operation encountered SQL Server error 47106 and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry the ALTER AVAILABILITY GROUP JOIN command.
June 8, 2020 at 12:34 pm
Duplicate of: https://qa.sqlservercentral.com/forums/topic/sql-2017-aoag-setup-on-standalone-servers
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 10, 2020 at 10:52 am
Try running the below command in the master database on the instances involved.
Grant Alter Any Availability Group to [NT Authority\System];
after that, try to recreate the availability group again. I find it better to script the creation and run commands manually to see where it is failing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply