Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Add Replication to a SQL 2005 SP2 Standard Edition instance of SQL -- how to do this? Expand / Collapse
Posted Thursday, July 31, 2014 10:33 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 4, 2015 9:45 AM
Points: 216, Visits: 1,050
Hi everyone,

We have a SQL 2005 SP2 Standard Edition server (9.00.3042) we need to make a Distributor, but the Replication components weren't installed when the server was initially installed from RTM and it's now on SP2. When I try to use the SQL 2005 RTM media (9.00.1399.0) it says it can't install an older version of replication on a newer version of SQL. I checked MSDN and they don't have SQL 2005 with SP 2 available. And from what I've read Slipstreaming with SQL 2005 doesn't work.

So what to do? I read some work around with editing the registry to set the IsInstalled to '1' and adding the DLL's manually, or installing from command line then editing the registry. I hoped though there was a documented way of doing this per Microsoft's suggestions, but thus far I can't find any. But in the end whatever works...

Thanks for any suggestions or ideas.

Post #1598371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse