Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2436
  • Last Modified:

Initializing SQL Server Reconciler has failed Error 29045

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:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/sql_serverce_replication_net.asp (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 vb.net and I'd like to use c#)
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcemergereplication.aspx  (I'm using this to develop my client side c# code to connect to the database)
http://www.databasejournal.com/features/mssql/article.php/1438231 (I've been using this to supliment the other resources)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/fieldservice_sp.asp (This is the sample app that sparked my interest in doing this)

http://www.dotnet247.com/247reference/msgs/35/177619.aspx (these are some things that other people with my similar problem did to solve it....but not me)
http://www.dbforums.com/showthread.php?t=926219&page=1&pp=15 (this one as well, didn't solve my problem)

Please help!  I will try anything to get this to work correctly!  
0
steven808
Asked:
steven808
  • 3
  • 2
1 Solution
 
steven808Author Commented:
I've also read about this issue at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_troubleconnect.asp
But didn't find a resolution.  :(
0
 
ispalenyCommented:
steven808,
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


0
 
steven808Author Commented:
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.
0
 
ispalenyCommented:
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.
0
 
steven808Author Commented:
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.  :(

Thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now