SQL Server Club
Home Articles Essential Guides Blogs Links Twitter Facebook Join Contact About
How to Install SQL Server 2005 Replication - A Simple Guide - Part 2 of 2
Web Monkey About the Author

With security clearance and well over a decade of experience with SQL Server, Web Monkey is the resident DBA at Norb Technologies and a real database guru.

A regular contributor to SQL Server Club, his background includes software development, hardware, a smattering of essential networking knowledge and an unhealthy interest in web security. He has an obsession with automating repetitive tasks, but has a tendency to forget where he left his last open bag of fruit and nut...

Typepad Profile RSS Feed Web Monkey on Twitter
Send to a Friend Printer Friendly Version
Welcome back...

Right click on the Replication tree node in SQL Server Management Studio (SSMS) again and this time click on the Configure Distribution menu item to bring up the Configure Distribution Wizard:

Configure Distribution for Replication on SQL Server 2005
This should bring up the following Configure Distribution Wizard window:
The Configure Distribution Wizard for Replication
Click on the Next button and simply navigate through the Distribution Configuration Wizard according to your replication needs - this will vary from company to company, but the wizard is self-explanatory. If you need to go away and find out more information before proceeding, you can click the Cancel button and return to this step at a later time, but right clicking on Replication and choosing Configure Distribution again.

Once you have been through each of the configuration steps, you should reach the final screen of the Wizard to show successful completion:
SQL Server Replication has been Successfully Set Up
Click on the Close button and return to Management Studio. Now right click on the Replication tree node one more time to confirm that replication is configured.

The menu should now have changed to this:
The Replication Menu has now Changed
Well done! - Replication is now set up and you're ready to start distributing data!
Want More SQL Server Articles, Tips and Expert Advice?
If you liked this article please join SQL Server Club to receive our newsletter. Membership is free and you'll be first to hear about new articles, performance tuning tips written by practising DBAs, industry news, blogs, interviews and lots more.
Join SQL Server Club Today
Send to a Friend Printer Friendly Version
Part 1 || Top of Page
© Norb Technologies 2007-2010 Privacy Policy Norb Technologies Devdex Feedback Home
Feedback Form