Lesson 2: Preparing the Snapshot Folder
New: 17 July 2006
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 2005 data folder. The default location is C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.X\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.