June 22, 2008 at 8:19 pm
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 MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
December 24, 2010 at 7:44 am
hi
i have exactly same problem i guess
have you found a solution?
regards
seb
July 19, 2012 at 9:33 am
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)
August 23, 2014 at 7:54 am
Worked for me and thanks much. Saved my saturday.
start /wait P:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Replication
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply