SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installing Replication Components on Existing Instance


Installing Replication Components on Existing Instance

Author
Message
Timothy Ford-473880
Timothy Ford-473880
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1653 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
seppevdh
seppevdh
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 109
hi
i have exactly same problem i guess
have you found a solution?
regards
seb
DB_Newbie2007
DB_Newbie2007
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1048 Visits: 1346
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! Smile

Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
box1805
box1805
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 207
Worked for me and thanks much. Saved my saturday.

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


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search