I have a SQL 2005 Express Edition system on which I applied SP2. Now, I have been asked to add the replication feature that was earlier not installed. I have tried using 1. Control Panel/Add Remove Programs/Microsoft SQL Server/Change ... Provided the path to sqlrun_sql.msi file. Selected Replication and completed the instalaton but it doesnt work. 2. Ran the original installation file but it did not allow to install replication. Is there any other step that I can try to install replication without Uninstalling/reinstalling the whole thing ?
If you have applied SP2, then you need to install the feature from installation media with the same SP. If the original installation media are without SP, you cannot add the feature to installation with SP applied. So there are 2 options: 1. Use installation media with the same SP applied 2. Remove the SP from the installation to which you need add feature, Install the feature from original media and the apply the SP again.