Re: Server CE 2.0 Merge Replication

Darren, thank you for your answer!

This morning I am not able to access sscesa20.dll both from the emulator nor
the device: The page you are looking for can not be found.

My machine has a IP address (ipconfig). When I use the IP address instead of
the computer name in trying to access sscesa20.dll the answer is: Unable to
connect with current settings. To change your connection settings, tap
Settings.

When I try to replicate (.synchronize) the result is as follows:
A request to send data to the computer running IIS has failed.... Native
error: 28037, HR: -2147012867

Many thanks
Paul


"Darren Shaffer" wrote:

> the machine that IIS and SQL Server are running on must either have
> an IP address or being running the Microsoft Loopback Adapter.
>
> your first goal should be to access the server agent from Pocket IE
> on device or consistently in the emulator. if that is not happening, then
> please post the specific error message and HRESULT that is being
> reported when you attempt to replicate.
>
> --
> Darren Shaffer
> ..NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "poeilu" <poeilu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:09A1BEE7-B273-4130-A01D-AD1FC1CACDF2@xxxxxxxxxxxxxxxx
> > Please HELP!!!
> >
> > I try to reproduce the <Programming Microsoft SQL Server CE 2.0 Merge
> > Replication with the .NET Compact Framework> Lab step by step.
> >
> > Because I cannot manage to get the replication working for weeks
> > I think it will be best to ask you all
> > the single points where I am not sure if I got it correctly:
> >
> > My computer name be XXX (instead of TWEEDLEDEE)
> > My SQL Server instance name be YYY (instead of TWEEDLEDEE)
> >
> > ------------------
> > SQL Server Login Properties: The Lab says Grant the user IUSR_XXX access
> > to
> > the database but the permissions are not visible; I assume that
> > db_datareader
> > and db_datawriter are neccessary - is this correct?
> >
> > what is the MSmerge 9999999etc. permission? Is this necessary? I did grant
> > this one as well.
> > --------------------
> >
> > In Windows Explorer I share the folder \Snapshot (in the folder \Labs)
> > with
> > the share Name PhiloTrackSnapshots and grant it Read AND CHANGE
> > Permissions;
> > is this ok?
> >
> > I do NOT share the Labs folder itself at all - is this ok?
> > I do NO Web Sharing at all on any folder - is this ok?
> >
> > ------------------------
> > In the publication properties I define \\XXX\PhiloTrackSnapshots as the
> > Snapshot folder (i.e. the SHARE name of the folder Snapshot and NOT
> > \\XXX\C$\Labs\Snapshot). is this ok?
> >
> > In the Status tab I run the Snapshot Agent and the first snapshot is
> > created
> > in
> > \\XXX\PhiloTrackSnapshots\unc\XXX$YYY_PhiloTrack_PhiloTrack\20051123075704
> > and can be explored in the Status Tab perfectly (PhiloTrack is the name of
> > the publication as well as of the database).
> >
> > -------------------------------------------------------------- --------
> >
> > In Programs/Microsoft SQL Server CE 2.0 I run the Configure Connectivity
> > Support in IIS and double click on Create a virtual directory.
> >
> > For the Alias I give PhiloTrackAlias and for the folder for sscesa20.dll I
> > give C:\PhiloTrack\TempFiles\ (i.e. the PHYSICAL path to the dir to be
> > created) - is this ok?
> >
> > Should this local path be granted any permissions in the Virtual Directory
> > Properties? The Lab doesn't state anything such...
> > --------------------------------
> >
> > Internet Explorer ON THE DESKTOP (XXX) does connect to
> > http://XXX/PhiloTrackAlias/sscesa20.dll without any problem (stating SQL
> > Server CE Server Agent).
> >
> > The Pocket Emulator does not (The page you are looking for cannot be
> > found)
> > When I change to the IP Address for XXX instead it is <Unable to connect
> > with
> > current settings. To change your connection settings, tap Settings>. What
> > do
> > I
> > have to change here???
> >
> > BUT: I happened to be able to connect via the Emulator sometimes and
> > then -
> > maybe booting the PC was enough to not beeing able to connect anymore - I
> > have
> > no idea whatsoever, how all this works together. It seems very
> > unpredictable
> > and anreproduceable to me.
> > ---------------------------------
> > In SQL Server Enterprise Manager/Replication Monitor/Snapshot Agents the
> > Snapshot Agent for my publication PhiloTrack ist stated with a status of
> > Succeeded (A snapshot of x articles was generated...) BUT the icon on the
> > left side of the agent shows a red dot thus seems not to be running - is
> > this
> > correct. When I try to start the agent, nothing seems to be happening, the
> > red dot remains there. Has the agent to be running all the time?
> > ---------------------------
> >
> > I would greatly appreciate when somebody could answer all my questions
> > mentioned above and maybe point me to other possible problems making this
> > replication working!
> >
> > Any explanation from you that hlps me understand how this works will be
> > greatly appreciated!
> >
> > Thanks very much for any help on this!
> > Paul
> >
> >
> >
> >
> >
> >
>
>
>
.

Relevant Pages
Loading