Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error: Initializing SQL Server Reconcilier has failed Expand / Collapse
Author
Message
Posted Wednesday, December 29, 2010 8:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #1040352
Posted Wednesday, December 29, 2010 8:43 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
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
Posted Wednesday, December 29, 2010 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, December 29, 2010 9:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
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
Posted Wednesday, December 29, 2010 10:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, January 04, 2011 6:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
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 »

Add to briefcase

Permissions Expand / Collapse