Initializing SQL Server Reconciler has failed Error 29045

Posted on 2005-05-09
Last Modified: 2007-12-19
I've been trying to figure this problem out for days now and I just can't seem to figure it out.  So if anyone can help, that would be awesome!

So this is simply how I'd like things to be:
All I want to do is connect to an sql server 200 database from a pocket pc.  I'm using C# to develop the client side.  I'm using SQL Server 2000 sp3a on the server side.  And I'm using SQL Server 2000 CE 2.0 sp3a to interact between the two.  And I'm using IIS 6.0 to communicate over the internet.  

This is what's going on:
I've gone through every tutorial, how to and step by step to correctly setup sql server 2000 and the publication.  I've also done the same for double checking the user permissions for the database.  At this point, I've basically given everyone full control over everything.  I've create a virtual directory for SQLCE and gave full control over that.  I've registered both the sscerp20.dll and the sscesa20.dll's.  I've created a virtual directory in iis that points to the same directory as sqlce.  I've added the IUSR_PCname access to everything everywhere.  But no matter what I do, I can't get it to work.  I'm able to view and browse and read my virtual directory from the handheld, but I can't get it to work from my own application.  I've un-installed and reinstalled everything at least 10 times and did them in different sequence.  I cannot figure this out.  SQL server 2000, IIS, and SQLCE are all installed on one server, windows server 2003 and I'm developing the client side on another pc, running windows xp.  I've checked the Event Viewer and it's saying that my user is sucessfully logging on....but my app is still giving me that error, no matter what.  Sorry for such a messy description....but my brain is mush right now.  :(

Here are the references that I've used so far with no success: (I'm using this as a template to configure sql server 2000, the virtual directories, publications, user permissions...I basically stop at the user interface because that's using and I'd like to use c#)  (I'm using this to develop my client side c# code to connect to the database) (I've been using this to supliment the other resources) (This is the sample app that sparked my interest in doing this) (these are some things that other people with my similar problem did to solve it....but not me) (this one as well, didn't solve my problem)

Please help!  I will try anything to get this to work correctly!  
Question by:steven808

    Author Comment

    I've also read about this issue at:
    But didn't find a resolution.  :(
    LVL 13

    Expert Comment

    I am not able to read all articles and follow references in them. But I collected some hints from users of SQL CE:

    Register sscerp20.dll and sscesa20.dll.
    Snapshot folder must be a Windows share
    Give propper rights on publication database
    Use IP instead of hostname


    Author Comment

    Hi ispaleny,

    Thanks for those hints, but those are the ones that I've been doing.  The only difference between what all those references say to do and what I'm doing, is that I'm developing the c# on a different computer from where the sql server db is.  Other than that, I've done everything I can think of.

    thanks again.
    LVL 13

    Accepted Solution

    1. Are you able to reach SQL Server distribution database and the network share under account running C# on XP?
    2. I would run Filemon capturing file access errors and SQL Profiler capturing SQL errors on the server.

    Author Comment

    1.  Yes, I'm able to either go through iis or locally over my network.  I'm also able to view the files over iis through the Pocket PC 2002 emulator as well.
    2.  I haven't used Filemon, but at quick glace it seems it will be very helpful in seeing what's actually going on.  Thanks, I'll try that asap.  But I have used the Windows Event Viewer, and it is showing that I'm logging into the directory with the correct parameters.  But for some reason I'm getting that 29045 error.  :(


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now