Re: SQLCEReplication over GPRS


Hmmm. Well, those are the things that occurred to me and we're now well
beyond what I can think of. I have the following comments from other MVPs
on this topic:

1. The default setting for publishing a web site that you use in ISA screws
up the HTTP headers when synching with merge. Some enterprises stumble on
this but it's just a check box that needs to be unchecked.

Not sure if you're using ISA or not. If it works generally, from the
Internet side, just not over GPRS:

2. Just a FYI, we've had some problems with GPRS merge replication that were
specific to companies who had Vodafone as their mobile operator, but the
symptom was a error message about HTTP headers getting corrupted. That error
is the same as when security software messes with HTTP requests, and we have
found out that Vodafone was trying some kind of compression over their
network that was causing the issue.

Maybe this explains it. You could try another carrier; that's probably the
easiest test.

Paul T.

"Jon Hopper" <JonHopper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D31521E9-25D4-49F4-AD15-C43BF791AFB0@xxxxxxxxxxxxxxxx
-yes I have tried it without requiring IIS authentication and it works.

-yes we are using SQL CE 3.0 on the device

-When accessing the dll via the browser it asks for a username and
password
which once supplied is accepted

The SQLCEReplication settings are:

InternetLogin = <<IIS Login>>
Publisher = AGL-DB-01
PublisherDatabase = CarmaMobilePublication
PublisherLogin = = <<Publisher Login>>
Publication = p_mitour1
Subscriber = TourGuide
HostName = DeviceID

InternetPassword = <<IIS Password>>
PublisherPassword = <<Publisher Password>>
SubscriberConnectionString = Data Source=\Internal
Storage\KwikTAP\data\DB.sdf;Max Database Size= 500
QueryTimeout = 1200
ConnectionManager = true
InternetUrl = http://carma-v-app-02.alchemy.co.nz:8080/sqlce/sqlcesa30.dll



"Paul G. Tobey [eMVP]" wrote:

Also, have you *tried* this with no IIS authentication required. I
wouldn't
feel comfortable with that as the long-term setting, but it would be
worth a
test. Please show how the replication set up is made, too. I'd like to
verify that you're telling SQL CE the correct authentication settings
(you
can obfuscate the actua user names and passwords, but please show
<user1>/<password1> and <user2><password2> only if they are different, so
we
can verify any possible confusion between SQL Server user names and
passwords and IIS user names and passwords.

Paul T.

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam
DOT
com> wrote in message news:uFkbnNhWJHA.4384@xxxxxxxxxxxxxxxxxxxxxxx
I guess I should ask whether you're really using SQL CE 3.0 on the
device,
as that's the server sync DLL version that you're using. I think that
you
must be, if that DLL/server path actually works when you're connected to
the local network. What happens, also, when you properly enter the user
name and password when trying to access the replication DLL via the
browser
on the device?

Paul T.

"Paul G. Tobey [eMVP]" <p space tobey no spam AT no instrument no spam
DOT
com> wrote in message news:ujKz$ChWJHA.552@xxxxxxxxxxxxxxxxxxxxxxx
I suppose that Vodafone could be responsible for that. You're saying
that, if you connect to the server, via the Internet but just not via
Vodafone GPRS, it works fine? If Vodafone is the only variable,
they're
the problem. GPRS is just a network connection. I can't imagine that
SQL
Compact even knows that it's using GPRS...it should just be 'a network'
as
far as SQL CE knows. I'll think about it...

Paul T.

"Jon Hopper" <JonHopper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1816C0D-BB94-4C34-915B-61DA62889ECC@xxxxxxxxxxxxxxxx
we have a windows mobile 6 device which syncs with a SQL Server
Database
via
SQLCEReplication from within our c# based application.

No the server currently isn't set up with https.

Connecting via a PC either inside our network or from outside the
network we
can authenticate via our applictaion using the SQLCEReplication, but
when
connecting via GPRS via vodafone the authentication part is missing.

Using a web browser via GPRS to connect to the sqlcesa30.dll it asks
for
a
username and password accordingly.





"Paul G. Tobey [eMVP]" wrote:

Maybe there's a problem with your firewall? With no information
about
network topology and security, anything we come up with is just a
guess.
You've set up the IIS server to use https:? Doesn't seem like
transmitting
a clear-text user name and password over the Internet is a great
idea.
You've opened a hole in the firewall (both on the server PC and at
the
corporate interface to the Internet), to allow this traffic? You've
installed the server's certificate (for HTTPS:), onto the PDA?

Paul T.

"Jon Hopper" <Jon Hopper@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DAC0D7AF-2F81-4F30-9012-04482430F7EE@xxxxxxxxxxxxxxxx
I have an application which I am attempting to sync over GPRS.

I have setup the sqlcesa30.dll within IIS to use basic
authentication.
When
the PDA is docked with the PC and the data goes out through the PC
the
sync
works fine.

However when attempting to sync over GPRS the authentication is
missing
when
the request reaches the server (checked the incoming packets and
checked
the
IIS logs)

Is there a way to ensure the authentication details are within the
outgoing
packet when using GPRS?

I am assuming the authentication is there when leaving the PDA
basing
on
it
is working when connected via the desktop. How can I get it
working?












.

Relevant Pages

  • Re: Kerberos machine authentication - apparent authentication fail
    ... > until logon), the wireless connection can kick off when it is ready. ... > was confirmed in the server event logs with IAS (i set that up as the radius ... > as an ordinary user kicks in and takes over from the machine authentication. ... > while the network sorts itself out and a double click on a network link of ...
    (microsoft.public.windows.server.security)
  • RE: [fw-wiz] IPv6 comes in the game
    ... Microsoft Windows 2000/2003 server does 802.1x auth fine. ... wireless access as well as port access on certain switches in the network. ... then you're able to log the authentication at the RADIUS ...
    (Firewall-Wizards)
  • Re: ipfw plus authentication (authpf is cool but....)
    ... authentication happening in the process of dhcp. ... router first before being allowed to access any server. ... script will happily change the router's firewall ruleset to allow the ... user does not want to access any network server anymore. ...
    (freebsd-questions)
  • Re: Access Denied to share with anonymous access disabled
    ... > Integrated Windows authentication, then you are looking at the classic ... > server, why should the server automatically be able to use your ... > to access some other network resource? ... > ASPNet local user account full access to the share. ...
    (microsoft.public.inetserver.iis.security)
  • Re: SQLCEReplication over GPRS
    ... Paul T. ... we aren't using an ISA server and unfortunately ... Internet side, just not over GPRS: ... verify that you're telling SQL CE the correct authentication settings ...
    (microsoft.public.dotnet.framework.compactframework)
Loading