Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installing Replication Components on Existing Instance Expand / Collapse
Author
Message
Posted Sunday, June 22, 2008 8:19 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
I have the following:
4-node, 3-instance SQL 2005 64-bit Enterprise SQL cluster on Win2K3 64-bit O/S.
SQL instance install occured 8 mos. ago
Instance has been patched to SP2
Replication components not installed originally

Therefore if I attempt to configure distribution I get the following error: 21028: Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server.

I've already attempted 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= ADDLOCAL=SQL_Replication (failed as well)
3. Setup.exe from media, modify existing instance (failed, components already installed...)

The issue seems to be that since Replication components are a sub-category of Database Services, and DB Services are already installed, the installation engine does not see that there is anything to upgrade. There is also the issue that if I am able in some manner (with your help) to install replication components, that they'll be in RTM whereas the instance is at SP2. Will the instance function long enough for me to upgrade the replication components to SP2?

HELP!




- Tim Ford, SQL Server MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford
Post #521486
Posted Friday, December 24, 2010 7:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:31 AM
Points: 2, Visits: 78
hi
i have exactly same problem i guess
have you found a solution?
regards
seb
Post #1039113
Posted Thursday, July 19, 2012 9:33 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:59 AM
Points: 189, Visits: 1,207
I had a similar issue (tried to install Replication after the initial install/patch of SP). Trying to run via the Media (Setup.exe) and adding replication failed (version issue error messages).

I was successful running the following (P: is the drive containing the media on my server) via the command line:

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

Also found the following URL that may help you:

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2005-replication.aspx

Good luck! :)


Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
Post #1332304
Posted Saturday, August 23, 2014 7:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:22 PM
Points: 2, Visits: 192
Worked for me and thanks much. Saved my saturday.

start /wait P:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Replication
Post #1606655
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse