HDTutorial
EN
SQL DBA Tutorial 179-How to setup Replication with AlwaysOn Availability Group in SQL Server P1

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SQL DBA Tutorial 179-How to setup Replication with AlwaysOn Availability Group in SQL Server P1

26,556 views October 28, 2015 26:48

Watch on YouTube
ChannelTechBrothersIT

Description from the creator

In this Part 1 video you will learn following:
1- How to setup replication with AlwaysOn Availability Group in SQL Server
2- How to configure Remote Distributor in SQL Server
3- How to enable Replication on all Replica in AlwaysOn Availability Group
4- How to add possible publisher at remote Distributor in AlwaysOn Availability Group
5- How to Validate replication
6- Resolution of below Error:
Msg 21892, Level 16, State 1, Procedure sp_hadr_validate_replica_hosts_as_publishers, Line 60
Unable to query sys.availability replicas at availability group primary associated with virtual network name '' for server names of the member replicas:error = 18456, Level 14, State 1, Message: Login Failed for user 'NT AUTHORITY\ANONYMOUS' ..'


Step by Step SQL Server DBA Tutorial By TechBrothersIT
techbrothersit.com/search/label/SQL%20Sever%202…

About this tutorial

TechBrothersIT published this 26:48 video tutorial on October 28, 2015. It has been watched 26,556 times on YouTube.

Duration
26:48
Published
October 28, 2015
Views
26,556
Likes
126

Tags

Share

This tutorial in other languages