Note: A tac case have been opened, I am just posting this for a wider audience.
Unity 4.0.4 (Primary and Secondary)
SQL 2000 SP3 (800.760)
Exchange 2003 off box
Failover config runs fine on the primary server.
When running it on the secondary server, it errors out at the configuring sql replication
Error: "Failed to Configure SQL Replication"
After hitting OK, it does not terminate the wizard, but rather continues to the end and says failover config was successful.
Looking at the logs:
Error [0x800436e5] : [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL replincrementlsn extended procedure or one of the DLLs it references. Reason: 126(The specified module could not be found.). [Microsoft][ODBC SQL Server Driver][SQL Server]The subscription could not be updated at this time. [Microsoft][ODBC SQL Server Driver][SQL Server]The subscription could not be created.
CAvSQLRep::CreateTransSubscription(SFG-HOU-VM2 UnityDb UnityDbPublication UnityDb) returned [0x800436e5]
Disconnecting from the SQL Server on 'SFG-HOU-VM1'
I noticed that all the tables in the secondary server were blank, so were the publications on the primary server.
I googled it and most of the hit mentiond
to verify if xprepl.dll dll is the correct version listed in the sp3 sp_help file.
Suggestion was to reinstall SP3.
Will SQL 2000 SP4 work in this case?
Is it supported on Unity 4.0.4?