|
|
|
 |
| How to Install SQL Server 2005 Replication - A Simple Guide - Part 1 of 2 |
|
 |
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...
 |
|
|
|
|
| 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: |
 |
| Figure 1: 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: |
 |
| Figure 2: Replication has not been Installed on this SQL Server |
| 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...
 |
 |
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. |
 |
|
 |
|
|
|
|
|
| Part 2 || Top of Page |
