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

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

• bxcv

  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
  

• DennisV

  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

  
  

• Ventmore

  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.
  
  

• Echo

  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.
  
  

• Ryan Sun

  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.
  

• Ken Holcombe

  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.
  
  

• techme

  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
  

• DOMcCrea

  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.
  
  

• George Neo

  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.

  
  
  

• wuchisan

  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..
  
  
  =(
  

• Cybergenius

  when i type http://IP_address/Virtual_dir_alias/sscesa20.dll
  
  the SQL Server CE Server Agent is shown in my browser
  

• Arild Fines

  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
  
  

• PMNJ

  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...
  

• Rob Volk

  June, Could you also please post the connection string you are using to connect to the server.
  
  
• error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0