I am having an issue here with Unity 4.2.1. We upgraded 4.0(4)SR1 to 4.2.1, SQL2000 SP4 is installed. We now wanted to add failover. We do have the failover license.
First we ran the failoverconfig.exe on the primary, and it returned an error saying can't find the REPLDATA folder. We manually added the folder and it ran ok on the primary.
Now, we ran failoverconfig.exe on secondary(we did manually added the REPLDATA folder as well), the configuration failed at "Waiting for SQL distribution agent to complete". We went back to the primary and see the error is "invalid descriptor index" in UnityDBPublication.
Before the upgrade, Unity is running with MSDE2000 SP3a and we did upgrade to SQL 2000 SP4. If we try to upgrade the SQL again, it won't allow you because we are using SQL already.
Any input is appreciated.