error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

hi,

i'm using SQL Server CE 2.0 in my application.
When i try to synchronize my database by calling

replicator.Synchronize();
errors :
Initializing SQL Server Reconciler has failed.
process could not connect to Distributor
SQL Server does not exists and access denied.

what i did right now is i try to register

regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll"
regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll"

both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!!

I do not know what's going wrong..=(

Who can help me?!!! HELP~~~~~~~~~

thanks..

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.|||Just my two cents....

Also check whether you are able to browse the URL or not
/VirtualDirectoryName/sscesa20.dll">http://<IIS-Box-Name>/VirtualDirectoryName/sscesa20.dll from device?
Are you able to browse the general internet/intranet from the device?
If you are able to do both of the above then both connectivity on the device and on the IIS are setup correctly.|||Hi June...
I am also facing the same problem regarding the Initializing SQL Server Reconciler has failed using SQL Server CE 2.0......in my case it happened when i raised the data size in the database befor sync. Actually i am new to this tech can u pls tell me in detail bout wat xactly these dll are for and how to run
"both of the DLL files were succeed register" wat does this mean...pls do take some of ur time to answer my query.It will be a gr8 help from ur side.....

Thanks in advance to you.
Regards,
Asheesh.|||I'm sorry for late response..I've been disconnected from Internet for few days...
By the way, how to connect to my distributor. Actually my distributor is same as my publisher...|||when i type http://IP_address/Virtual_dir_alias/sscesa20.dll

the SQL Server CE Server Agent is shown in my browser|||Hi, Asheesh...

I facing this problem just i try to pull a table from my SQL Server 2000 to my emulator's local database using SQL Server Ce 2.0. I did not try to raise my data size since i just want to create a new database for my emulator. However, i assume i succeed to connect my sscesa20.dll since when i try to browse sscesa20.dll, SQL Server Ce Server Agent message is shown in my browser (no matter in desktop IE or emulator IE)

I try to search online, some suggest that the error occur because of the DLL file that correspond to the SQL Server CE Replication provider is not registered on the computer where SQL Server CE Server Tools is installed. That's y i tried to manually register this DLL file.|||

Mahesh Dudgikar wrote:

June,
Can you connect to the distributor using osql?
Typically, remote connections are disabled by default after installations.
If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

Hi Mahesh,

thanks for reply...

what is SAC...^^;;
i do not know what is that...?

thanks

best regards,
june|||

Hi June,
SAC is Surface Area Configuration Tool that lets you manage how connections are done to this instance of SQL Server.
To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server.

Also try connecting to the SQL Server from a remote machine using osql to see if you can connect to the server.

|||Hi Mahesh,

I'm sorry, i didn't mention my SQL Server version in my previous message. Actually i'm using SQL Server 2000...I'm not sure whether SQL Server 2000 having SAC feature..However, i didn't get Configuration Tools in from my MS SQL Server folder...:(

thanks...

june|||And I assumed this was SQL Server 2005 :) dont know why I was under that impression. SAC is only with SQL Server 2005.

So now, you have SQL Server 200 SP3 or SP4?
Can you also try registering replrec.dll? This should be in %ProgramFiles%\Microsoft SQL Server\80\COM directory and retry the synch please.|||June, Could you also please post the connection string you are using to connect to the server.|||Hi,

i'm using SP3a for my SQL Server 2000.
I registered the replrec.dll and re-sync..the error still remain

error messages:
initializing SQL Server Reconciler has failed
process could not connect to Distributor
SQL Server does not exist or access denied..
=(|||Few more questions:
1. Have youever synched successfully previously with this device (subscriber) and publisher?
2. Is this reinitializing?
3. What about permissions for snapshot folder and other items for IIS/SQL Server service. When you setup the virtual directory did you provide all the accounts permissions?|||

ok...my replication declaration:

private const string INTERNETURL = "http://localhost/Northwind/sscesa20.dll";
private const string PUBLISHERSERVER = "TWEEDLEDEE";
private const string PUBLISHERDATABASE = "Northwind";
private const SecurityType PUBLISHERSECURITYMODE =
SecurityType.NTAuthentication;
private const string PUBLICATION = "NorthwindProducts";
private string SUBSCRIBER = Dns.GetHostName();
private const string LOCALDATABASE = "\\My Documents\\products.sdf";
private const string CONNECTIONSTRING = "data source = " + LOCALDATABASE;

i do not sure is it my snapshot folder problem...i'm confuse to the snapshot folder that i created during creating my publication and during set up my virtual directory folder. When i create my publication, my snapshot is C:\Labs\Snapshot (i follow the tutorial)
However, when i set up my virtual directory and enter d same path (C:\Labs\Snapshot), it pop up a message said unable to found the file. Then i enter the snapshot folder as
\\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\ReplData

HOWEVER, when i check out my snapshot location using Enterprise Server
there stated it as \\computer_name\C$\Program Files\Microsoft SQL Server\MSSQL$TWEEDLEDEE\REPLDATA
under generate snapshot in the following location