Snapshot Replication (Setting up Publisher) in SQL Server 2008: Part 2

In this article you will learn Snapshot Replication (Setting up Publisher) in SQL Server 2008.

This is a continuation of the Snapshot Replication in SQL Server 2008: Part 1. In these articles I'll shed light on setting up a publisher in Snapshot Replication and recommend that you read the article shown as a link. I thought to keep the pictorial concept so that anyone can easily setup and map at their end.


The Publisher can be denoted as Origin of the database on which the schema or record amendments take place. The Publisher is a point that manages the data for replication and sends commands to the distributor for further processing. For example, S1.


The Subscriber is a point where the subscriber database incurs the notification and a copy of the data from the distributor about the changes that have happened in the publisher database. The subscriber database generally lives on a different system, for example S2.

Setting up the Publisher

Step 1

Open the replication node in your database and choose the option Local Publications.


Step 2

Right-click on Local Publications and click on New publication.

new publications

Step 3

After clicking on the new publication tab the following window will appear and click on the “Next” button.

new publication tab

Step 4

Select the database that will act as a publisher. I've chosen DBCompany on my server machine. Then click on the “Next” button.

publication data

Step 5

The following window appears. Choose a snapshot replication option out of 4 options there and click on the “Next” button.

snapshot publication

Step 6

Select the objects you want to publish. For example I've selected the employee and Incentive table that need to replicate. (Kindly refer to the depicted image below.) Then click on the “Next” button.

select table

Step 7

The following window will appear. Click on the “Next” button.

filter table

Step 8

Kindly checked (tick) both of the checkbox. To change the scheduled time interval click on the change button and set the time as needed and that is also shown in the depicted image below and then click on "Next".

Note: it's not necessary to check the Schedule of the snapshot agent.

snapshot agent

Step 9

The following window will appear after clicking on the “Change” button. Please set an interval accordingly and refer to the image shown below and then click on the "OK" button.


Step 10

Click on the security settings button and choose the options from there as shown in the image below after this image.

security settings

enter publisher account

Step 11

After roviding the required value in the preceding image the following window will appear. Kindly press the "next" button to proceed further.

sql server agent account

Step 12

The following window will come. Click on the "Next" button.

end of the wizard

Step 13

Kindly fill in the Publication name in the TextBox with your desired name and click on the "Finish" button.

complet wizard

Step 14

The following window will appear for Successful creation of the Publication.

creating publication

Step 15

To confirm the publication has been created, kindly expand Local Publication as depicted in the image below:

local publication

                                    tips and tricks

I've run this under the SQL Server agent account as you saw above and also shown in the image below. You can try it with a Windows account also.

There is another point for consideration. That is, kindly enter the publisher SQL Server account credentials to connect with the publisher database.

run under the SQL

Thanks for reading this. I'll post more part soon.

To learn more about MVC please go to the following link.

MVC Articles
Enjoy Coding and Reading.