Error: Initializing SQL Server Reconcilier has failed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » Error: Initializing SQL Server Reconcilier...

Error: Initializing SQL Server Reconcilier has failed

Rate Topic

Display Mode

Topic Options

Author

Message

lmejia

Posted Wednesday, December 29, 2010 8:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 29, 2010 2:11 PM
Points: 3, Visits: 12

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 Sad

Post #1040352

GSquared

Posted Wednesday, December 29, 2010 8:43 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

Per the error messages, the "mercurio" server isn't responding to a login request. Is that server up and running? Does it respond to a ping?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1040362

lmejia

Posted Wednesday, December 29, 2010 8:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 29, 2010 2:11 PM
Points: 3, Visits: 12

Hello GSquared, thanks for answer

Yes, the server is running, in fact it has some applications running on IIS and it's open to public.
The user i am using for authentication in sql server is correct. I have verified it lot of times.

The syncronization was working correctly few days ago but now it does not work without apparent cause.

Post #1040375

GSquared

Posted Wednesday, December 29, 2010 9:24 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

Check the server logs on mercurio. Something changed, you just need to find what.

Maybe there's been a patch you don't know about. Maybe a firewall setting was changed. Lots of possibilities. Checking the logs will probably help narrow down the things to check.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1040404

lmejia

Posted Wednesday, December 29, 2010 10:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 29, 2010 2:11 PM
Points: 3, Visits: 12

Hello GSquared

unfortunately i only can see the past tree days and there is nothing related with this issue.

any other ideas about this? maybe something in the configuration?

Post #1040450

GSquared

Posted Tuesday, January 04, 2011 6:24 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

Not really. I'd pretty much just be poking around and talking to my network people at this point.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1042336

« Prev Topic | Next Topic »

Permissions