SQL Server Replication (Part 1) : Preparation

I have 2 servers : (already installed SQL Server 2008R2 Machine on Windows Server 2008R2)

Server Primary : IP 10.10.10.21 hostname WIN-92JP95SLO0R

Server Backup : IP 10.10.10.12 hostname WIN-FRHI57MGALL

On this part 1, before setup replication on SQL Server Management Studio, we need preparation :

1. Config hosts file on path

C:\Windows\System32\drivers\etc\hosts, append this line on both servers

10.10.10.21        WIN-92JP95SLO0R
10.10.10.12        WIN-FRHI57MGALL

Why we need do this ? Because when create subscriber, we need to connect SQL Server Machine by hostname, not IP, when we input IP Address, we will get error message like this : http://willyristanto.blogspot.com/2015/04/verfiy-that-instance-name-is-correct.html

2. Setup SQL Server Agent to start automatically

Open services.msc, right click on SQL Server Agent, click properties

Choose Startup Type : Automatic, then click start

Okay, part 1 finish, then we go to part 2