Lesson 2: Preparing the Snapshot Folder
In this lesson, you will learn to configure the snapshot folder that is used to create and store the publication snapshot.
To create a share for the snapshot folder and assign permissions
In Windows Explorer, navigate to the SQL Server data folder. The default location is C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data.
Create a new folder named repldata.
Right-click this folder and click Sharing and Security.
On the Sharing tab in the repldata Properties dialog box, click Share this folder. Ensure that the Share name value is repldata.
Click Permissions.
Click Add. In the Enter the object names to select text box, type the name of the Snapshot Agent account created in Lesson 1, as <Machine_Name>\repl_snapshot, where <Machine_Name> is the name of the Publisher. Click Check Names, and then click OK.
Repeat the previous step to add permissions for the Distribution Agent, as <Machine_Name>\repl_distribution, and for the Merge Agent as <Machine_Name>\repl_merge.
Verify the following permissions are allowed:
repl_snapshot - Full Control
repl_distribution - Read
repl_merge - Read
Click OK to close the Permissions for repldata dialog box.
Click Security, and then click Add.
In the Enter the object names to select box, type the name of the Snapshot Agent account created in Lesson 1 as <Machine_Name>\repl_snapshot, where <Machine_Name> is the name of the Publisher. Click Check Names, and then click OK.
Repeat the previous step to add permissions for the Distribution Agent, as <Machine_Name>\repl_distribution, and for the Merge Agent as <Machine_Name>\repl_merge.
Verify the following permissions are allowed:
repl_snapshot - Full Control
repl_distribution - Read
repl_merge - Read
Click OK to close the repldata Properties dialog box and create the repldata share.
Next Steps
You have successfully configured the share for the snapshot folder. Next, you will configure distribution. See Lesson 3: Configuring Distribution.