Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Unanswered: Error: Initializing SQL Server Reconcilier has failed. Try again

    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

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you check the errorlog on MERCURIO for 2010/12/28 at 11:50:11? Failed attempt to connect may be recorded there as well.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2010
    Posts
    3
    Quote Originally Posted by rdjabarov View Post
    Did you check the errorlog on MERCURIO for 2010/12/28 at 11:50:11? Failed attempt to connect may be recorded there as well.

    Hello, thanks for answer.

    I have cheked the sql server logs and the general system log but there is nothing about this issue.

    Any other idea? i appreciete your colaboration

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    This means that your MERCURIO is not accessible from the server where you're seeing these errors. That's your starting point.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Dec 2010
    Posts
    3
    Thanks rdjabarov

    I solved the issue.

    Like you said, the web server couldn't see the database server for firewall restrictions. I just add the 1433 port like exception and it works.

    Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •