Tutorial: Preparing the Server for Replication
It is important to plan for security before you configure your replication topology. This tutorial shows you how to better secure a replication topology as well as how to configure distribution, which is the first step in replicating data. You must complete this tutorial before any of the others.
Note
To replicate data securely between servers, you should implement all of the recommendations in Replication Security Best Practices.
What You Will Learn
In this tutorial you will learn how to prepare a server so that replication can run securely with least privileges. The first lesson shows how to create the Windows service accounts used to run replication agents. The second lesson shows how to configure the folder used to generate and store publication snapshots. The third lesson shows how to configure distribution and set permissions.
Requirements
This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to replication.
To use this tutorial, your system must have the following components installed:
- SQL Server 2005 or a later version with the AdventureWorks2008R2 database. To enhance security, the sample databases are not installed by default. For information about how to install the sample databases, see Considerations for Installing SQL Server Samples and Sample Databases.
Estimated time to complete this tutorial: 30 minutes.
Lessons in This Tutorial
Note
For reviewing tutorials we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.