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 Properties.
On the Sharing tab in the repldata Properties dialog box, click Share.
In the File Sharing dialog box, click Share, and then click Done.
On the Security tab, click Edit.
In the Permissions dialog box, click Add. In the Select User, Computers, Service Account, or Groups 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 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.