Merge agent is failing with the error: 'The proc

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Merge agent is failing with the error: 'The process could not initialize "database reconciler". Check to see if the component is registered correctly’. Where to look?

Again this is a problem with missing DLLs. Copy the any of the following missing DLLs from x86\Binn on the CD to “C:\Program files\Common files\Microsoft Shared\Database replication\” folder on the SQL Server computer:
rdistcom.dll replerrx.dll replprov.dll replrec.dll replres.dll sqldistx.dll sqlmergex.dll

(Continued on next question...)

Other Job Interview Questions

• Unable to drop a table even after removing replication. Getting the following errors, when try to drop or alter the table...
• Unable to specify a remote distributor for a Desktop/MSDE publisher. Why? How to start replication agents programmatically?
• How to change the replication working directory on the distributor?
• How to maintain IDENTITY property of a column on both publishing and subscribing databases in transactional replication?
• Unable to drop a table even after removing replication. Getting the following errors, when try to drop or alter the table...
• How to subscribe with ‘NOSYNC’ to a transactional publication?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• None of my replication agents are starting. The error message reads: ‘The step did not generate any output. The step failed’. How to correct this problem?
• A non-dbo owned table when merge replicated to the subscriber, is being owned by dbo. Is there a way to maintain table ownership in merge replication?
• Setup Transactional replication with "Immediate Updating Subscribers". Changes on publisher get replicated to the subscriber ...
• More...