MS SQLCE - Initializing SQL Server Reconciler has failed. HELP

Author

Initializing SQL Server Reconciler has failed. HELP

june

2005-09-23, 3:23 am

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\NorthwindTem
pFiles\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

2005-09-23, 3:23 am

i add more description for my creation of snapshot folder

Below is the way i create my snapshot forlder:

During installation of SQL Server 2000
my snapshot folder: \\BJUN- 23877657E6\Northwind
Snapshot

During Creation of Virtual Directory
my SQL Server Snapshot folder
\\BJUN- 23877657E6\C$\Progra
m Files\Microsoft SQL
Server\MSSWL$TWEEDLE
DEE\Rep
lData

i check out my snapshot agent under enterprise manager..the snapshot
agent
is running.

i do not know what's wrong with my configuration!!

HELP~~~~

june wrote:
> 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\NorthwindTem
pFiles\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..

Darren Shaffer

2005-09-24, 3:23 am

if you are using anonymous authentication, you need to make sure
the IIS default user IUSR_yourservername has been granted access
to the publication and the database as at least DB Reader and Writer.

that is why your sql agent cannot connect to the distributor.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"june" <myITWorld@gmail.com> wrote in message
news:1127461183.837075.79050@g44g2000cwa.googlegroups.com...
>i add more description for my creation of snapshot folder
>
> Below is the way i create my snapshot forlder:
>
> During installation of SQL Server 2000
> my snapshot folder: \\BJUN- 23877657E6\Northwind
Snapshot
>
> During Creation of Virtual Directory
> my SQL Server Snapshot folder
> \\BJUN- 23877657E6\C$\Progra
m Files\Microsoft SQL
> Server\MSSWL$TWEEDLE
DEE\Rep
> lData
>
> i check out my snapshot agent under enterprise manager..the snapshot
> agent
> is running.
>
> i do not know what's wrong with my configuration!!
>
>
> HELP~~~~
>
>
> june wrote:
>

ashish kumar

2005-09-27, 7:23 am

hi,
I saw the message posted here,i am also facinfg the same problem and
the error i am facing is

Error During Synchronization:
A native exception occurred.
ExceptionCode:0xc000
0005
ExceptionAddress:0x0
1627b28
Reading: 0x1e000000
OK to terminate
CANCEL to debug

While synchronizing data between the PDA and MS SQL Server database,
using Active Sync connection, the sync process fails at times and
displays an empty error message box and occasionally it shows the
following exception:

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync
connection drops as soon as the sync process fails. Later when the .SDF
file is deleted and restored the synchronization is successful.
Note: The replication monitor in the SQL Server indicates that the
synchronization was successful even when the above error occurs.

Steps to replicate:
1. The PDA is placed on the cradle and a manual connection is
established with the SQL Server database using the guest partnership.
2. The PDA application is invoked. Some data is saved in the local .sdf
file via the application.
3. The User clicks on the “Sync” menu option (Sample code below **) to
start the sync process
4. Most times the sync process is successful. Occasionally the above
issue is encountered.

** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)
Dim ce As SqlCeReplication = Nothing
Try
ce = New SqlCeReplication
'Set Internet properties.
ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"
'Set Publisher properties.
ce.Publisher = vPublisher '"CGH-RSMS"
ce.PublisherLogin = vPublisherLogin '"sa"
ce.PublisherPassword = vPublisherPassword '"xxxxxx"
ce. PublisherSecurityMod
e = SecurityType.DBAuthentication
ce.PublisherNetwork = NetworkType.DefaultNetwork
ce.PublisherDatabase = vPublisherDatabase '"RSMS"
ce.Publication = vPub_Name '"PUB_RSMS"
'Set Subscriber properties.
ce.Subscriber = vSub_Name
ce. SubscriberConnection
String = "Data Source=" & DB_PATH &
vDatabase_Name
If File.Exists(DB_PATH & vDatabase_Name) = False Then
ce. AddSubscription(AddO
ption.CreateDatabase)
End If
ce.Synchronize()
Catch ex As SqlCeException
If vShowMessage = True Then
MsgBox(ex.Message)
End If
Throw ex
Catch ex1 As Exception
If vShowMessage = True Then
MsgBox(ex1.Message)
End If
Throw ex1
Finally
ce = Nothing
End Try
End Sub

*** Sent via Developersdex http://www.droptable.com ***

ashish kumar

2005-09-27, 7:23 am

Sponsored Links