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 1 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
Installing Replication on SQL Server 2005
If you need to install replication on SQL Server, or if you have received the Microsoft SQL Server, Error 21028 [Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication.], here's a brief guide on how to install replication on SQL Server 2005.
Preparation:
First things first, you need to check if replication is already installed on your SQL Server. To do this, right click on the Replication tree node in the SQL Server Management Studio (SSMS) Object Explorer window:
Check if Replication is Installed on SQL Server 2005
Now click on the Configure Distribution menu item. If replication has not been installed on the SQL Server, the following message will appear:
SQL Server Error 21028
You will see in the lower part of the message the details for SQL Server Error 21028 - this is just SQL Server telling you that you have not yet installed Replication.
How to Install Replication on Your SQL Server 2005
To install replication on a base instance of SQL Server 2005, you ideally need to pop the original installation CD or DVD into its original drive, that is the same drive you used when SQL Server was initially installed.

If you do not have the original media (CD or DVD), or the original drive from which SQL Server was installed has changed or is unknown, simply copy the SQL Server 2005 "Servers" folder from an installation DVD onto the root directory of a local hard disk drive. This will then allow you to install from a location other than the original.

Once you've done this, run the following command from a DOS (or "command") prompt, assuming that the original SQL Server installation media is located on the X: drive:

SQL Server Club Membership Benefits
Articles written by experienced DBAs and developers Membership is free forever
Get your content published - articles, news, blogs, events No spam - guraranteed!
As a bonus and to thank you for supporting us, you'll receive a 20% discount off all Norb Technologies tools. Join today to take advantage of these benefits - join SQL Server Club now.


start /wait X:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Replication

If you get the following error message:

Installation package for the product SQL Server 2005 (64bit) cannot be found. Please locate a valid SQLRUN_SQL.msi

...then you may need to re-install the database engine files. This can be done very easily with the following command:

start /WAIT X:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REINSTALLMODE=v

Once this has successfully run, you then need to run the command to install replication again:

start /wait X:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Replication

Congratulations, you've successfully installed SQL Server 2005 replication, now you just need to configure it:

READ PART 2 OF THIS ARTICLE - Click Here to Read Part 2 of this Article >> >>
If you found this article useful, please visit our sponsors who keep us going...

SQL Defrag Studio 2009
Fragmented indexes can cause your SQL Server to gradually slow down until it grinds
to a complete stop. Performance may be slow but you'll need to solve it fast.

SQL Defrag Studio finds fragmented indexes and automatically defrags them for you.
Download
Send to a Friend Printer Friendly Version
Part 2 || Top of Page
© Norb Technologies 2007-2010 Privacy Policy Norb Technologies Devdex Feedback Home
Feedback Form