Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Error: Initializing SQL Server Reconcilier has fai

Author  Topic 

mejialuis28
Starting Member

1 Post

Posted - 2010-12-29 : 10:28:27
Hello, i have a problem when i try to syncronize with sql server replication.

the error is:

Error 29045 Initializing SQL Server Reconcilier has failed. Try Again

the HResult code is: 2147198719

in the sqlcesa LOG appear the following lines:

2010/12/28 11:50:11 Thread=148C RSCB=2 Command=SCHK Hr=80045901 ERR:Initialize failed for DistributorSessionID = 0
2010/12/28 11:50:11 Thread=148C RSCB=2 Command=SCHK Hr=00004E74 The process could not connect to Distributor 'mercurio'. 20084
2010/12/28 11:50:11 Thread=148C RSCB=2 Command=SCHK Hr=00000000 Unable to complete login process due to delay in opening server connection 0

The SQL Server database is in a Windows Server 2008 machine. 64 bits
The IIS is in a Windows Server 2003 machine 32 bits

I tried with regenerate the snapshot, restart IIS, run the job "Reinitialize subscriptions having data validation failures", disable distribution and enable it again. but anything of that works.


Any ideas? Is my 3 day with this issue :(
   

- Advertisement -