Cannot Install Replication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Cannot Install Replication

Author

Topic

scottpt
Posting Yak Master

186 Posts

Posted - 2007-11-28 : 08:20:04

I cannot get replication to install on an exsisting instance. SQL 2005 workgroup edition. it is at sp2, and it tells me that a more current version already exists.

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-11-28 : 08:29:58

What do you mean you cannot install it? What are you trying to do when you get the error? And what is the exact error?

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

scottpt
Posting Yak Master

186 Posts

Posted - 2007-11-28 : 09:16:16

I get Your upgrade has been blocked because the existing component is a later version that the on eyou are trying to install.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-28 : 09:19:25

Can you please explain what you are doing, from the beginning. What hardware are you trying to install it on, etc..

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-29 : 02:19:58

What do you mean install replication?

scottpt
Posting Yak Master

186 Posts

Posted - 2007-12-10 : 09:27:16

I installed SQL2005 Workgroup edition on a Windows xp 32bit box. Later on I wanted to add replication, I wnet in to setup and tried to installed it, vix support & books online, and it does not work. You must reinstall to add replication to a previously installed instance.

Replication is an option to be installed in sql 2005.

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-12-11 : 06:09:53

Yes I have seen it this way before. Are you still having any problems?

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-12-11 : 07:36:07

the message implies you need to use an installer with minimum sp2 to add the component

this link might help...

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

--------------------
keeping it simple...

dirtydavey
Yak Posting Veteran

80 Posts

Posted - 2007-12-11 : 08:55:01

Yes I have seen it this way before. Are you still having any problems?

Dave Dunckley says there is a law for the rich and a law for the poor and a law for
Dirty Davey.

SQLAgentMan
Starting Member

5 Posts

Posted - 2008-06-22 : 14:39:05

I'm having this same issue when attempting to install Replication components to an existing clustered node of SQL 2005 Enterprise Ed. 64-bit. I've not see any resolution on this topic. Can someone post a solution? I attempt to do this by modifying an existing install thru add/remove programs but since Replication is a subcomponent of DB services it will not let me, stating that the components already exist for the instance.

Timothy Ford, MCSD, MCP
Senior Database Administrator
Spectrum Health

Owner
Ford-IT Consulting Services

Author
SQL Server Central
MSSQLTips.com
Simple-Talk.com

Program Committe, SIG Committee, Editorial Committee
Professional Association for SQL Server (PASS)

Leader
West Michigan SQL Server User Group (WMSSUG.org)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-22 : 15:02:20

It comes with installation of SQL 2005 Enterprise Edition.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-22 : 17:01:00

>> I'm having this same issue when attempting to install Replication components to an existing clustered node of SQL 2005 Enterprise Ed.

Did you try config replication on the server? Got any error?

SQLAgentMan
Starting Member

5 Posts

Posted - 2008-06-22 : 18:17:28

Ray, when trying to configure distribution get 21028:

Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server.

Timothy Ford, MCSD, MCP
Senior Database Administrator
Spectrum Health

Owner
Ford-IT Consulting Services

Author
SQL Server Central
MSSQLTips.com
Simple-Talk.com

Program Committe, SIG Committee, Editorial Committee
Professional Association for SQL Server (PASS)

Leader
West Michigan SQL Server User Group (WMSSUG.org)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-22 : 19:27:58

Then start sql installation in control panel -> add/remove programs and add replication there.

SQLAgentMan
Starting Member

5 Posts

Posted - 2008-06-22 : 21:49:36

Have already done the following:
1. Control Panel/Add Remove Programs/Microsoft SQL Server/Change ... (failed, components already installed...)
2. Command line install to add replication to instance:
start /wait c:\...\setup.exe /qb VS=<VirtServer> INSTANCENAME=<InstanceName> ADDLOCAL=SQL_Replication (failed as well)

Timothy Ford, MCSD, MCP
Senior Database Administrator
Spectrum Health

Owner
Ford-IT Consulting Services

Author
SQL Server Central
MSSQLTips.com
Simple-Talk.com

Program Committe, SIG Committee, Editorial Committee
Professional Association for SQL Server (PASS)

Leader
West Michigan SQL Server User Group (WMSSUG.org)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-22 : 22:41:18

In this case, I'll try remove replication first then add it back in.

SQLAgentMan
Starting Member

5 Posts

Posted - 2008-06-23 : 10:32:02

Ray, won't let me alter the install in any way since it's at SP2.

Timothy Ford, MCSD, MCP
Senior Database Administrator
Spectrum Health

Owner
Ford-IT Consulting Services

Author
SQL Server Central
MSSQLTips.com
Simple-Talk.com

Program Committe, SIG Committee, Editorial Committee
Professional Association for SQL Server (PASS)

Leader
West Michigan SQL Server User Group (WMSSUG.org)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-23 : 22:41:47

Just tried on my sql2k5 sp2 machine, seems I can remove replication.

SQLAgentMan
Starting Member

5 Posts

Posted - 2008-06-24 : 14:33:21

Ray, it will not allow me to uninstall b/c it is not currently installed. If I try to install replication it will not let me b/c it is tied to the DB services and since it sees DB services as already being installed and at SP2 it will not allow adding replication as a subcomponent of DB services.
[url]http://www.ford-it.com/Images.htm[/url]

Timothy Ford, MCSD, MCP
Senior Database Administrator
Spectrum Health

Owner
Ford-IT Consulting Services

Author
SQL Server Central
MSSQLTips.com
Simple-Talk.com

Program Committe, SIG Committee, Editorial Committee
Professional Association for SQL Server (PASS)

Leader
West Michigan SQL Server User Group (WMSSUG.org)

betesh
Starting Member

34 Posts

Posted - 2008-06-26 : 04:05:33

I experienced this too and was advised to uninstall the whole SQL Server application and reinstall, but this time choosing the advanced option where you choose to install replication. This worked.

24x7x365
Starting Member

1 Post

Posted - 2009-05-08 : 07:58:06

Hi,

We have successfully fixed same issue on our Production Environment.

Here is the command line parameter fix for adding replication/other components on cluster environment.

*******************************************************************
C:\Software\SQL 2005 STD\Standard_x86\Servers>start /wait setup.exe /qb VS=SQL1 INSTANCENAME=SQL1 ADDNODE="xxxx1,xxxx2" GROUP="GROUP 0" IP="xxx.xx.xxx.xxx,Public" ADDLOCAL=SQL_Replication ADMINPASSWORD=xxxxx INSTALLSQLDIR="C:\ Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn"

*******************************************************************

Post installation Check - Check the registry key

‘HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Replication\IsInstalled’ for the value 1 post installation.

Once the above command completes successfully, replication components automatically gets upgraded to SP2/SP3. It automatically applies SP2/SP3 on the replication components if installed by the above method.

Default location for the replication components.

You could check the version of the replication dlls at the location below: “C:\Program Files\Microsoft SQL Server\90\COM”

Senthilkumar
Senior SQL Server DBA
India

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources