Re: SQL CE Synching Problems

Thanks for your help. I finally got it working. I didn't keep real good
notes on what I did to get it working so I am not positive what fixed it but
I did create a new virtual directory, this time pointint to the original
install location of SQL CE instead of under Inetpub like I had done before.
I also deleted and recreated the publication because I was still getting
some errors after that. I still don't understand why when I go to
properties of the publication in SQL and go to the status tab and click the
button that says show snapshot files I get an error message that it can't
find the files but it works so I will leave it alone. Thanks again for your
help.


"Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eYwYhWhSFHA.356@xxxxxxxxxxxxxxxxxxxxxxx
> Bruce,
>
> Have you granted IUSER_ServerName access to your publication within SQL
> Server?
> It looks like the permissions problem is getting access to the
publication.
> It appears you
> are indeed getting from the emulator to IIS successfully if you can go to
> Pocket IE on
> the emulator and get a response back from
> http://server_IP_address/SQLCEData/sscesa20.dll,
> so the issue has to be between the server tools and the publisher.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "Bruce Groen" <bruceg@xxxxxxxxxxxxxxxx> wrote in message
> news:e8gzGYfSFHA.3184@xxxxxxxxxxxxxxxxxxxxxxx
> >I ran the wizard again to check all the permissions and this is what it
> > showed:
> > [HTTP Content Folder Tab]
> > Folder = C:\Inetpub\wwwroot\SQLCEData\
> > Permissions:
> > Read Yes
> > Run Scripts Yes
> > Execute Yes (Greyed out)
> > Write Yes
> > Directory Browse No
> >
> > [HTTP Authentication Tab]
> > Anonymous Access Yes
> > Account Used for access:
> > ServerName\IUSR_ServerName
> > Basic Authentication No
> > Integrated Windows No
> >
> > [NTFS Permissions Tab]
> > Permissions for user ServerName\IUSR_ServerName
> >
> > Permissions for sscesa20.dll
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Write No
> >
> > Temporary file location
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Read Yes
> > Write Yes
> >
> > Permissions on \\servername\repldata (Snapshot folder for SQL)
> > For ServerName\IUSR_ServerName
> > Full Control No
> > Modify No
> > Read & Execute Yes
> > Read Yes
> > Write No
> >
> > I ran the program again from the emulator this time using the IP address
> > instead of the computer name and I got this error message:
> > ---------------------------------------------------------
> > Error:80072ee2
> > A request to send data to the computer running IIS has failed. For more
> > information, see HRESULT. [,,,,,]
> > Native Error:28037
> > Microsoft SQL Server 2000 Windows CE Edition
> > ---------------------------------------------------------
> >
> > I ran it again after walking through the wizard to confirm all the
> > settings
> > and this time I got this error message:
> > ---------------------------------------------------------
> > Error:80004005
> > Authentication failed on the computer running IIS.[,,,,,]
> > Native Error:28011
> > Microsoft SQL Server CE Edition
> > ---------------------------------------------------------
> >
> > I have a second computer that has IIS on it but does not have SQL on it
so
> > I
> > tried installing SQL CE 2.0 on it and point it to the other SQL server
for
> > the data. I have set it up for anonymous authentication but this is the
> > error I get when I point to that one via the IP address:
> > -----------------------------------------------------------------
> > Error:80004005
> > A call to SQL Server Reconciler failed. [,,,,,]
> > Native Error:29006
> > Microsoft SQL Server 2000 Windows CE Edition
> > Error:80045017
> > The process could not deliver the snapshot to the subscriber.
> > Native Error:0
> > Merge Replication Provider
> > -----------------------------------------------------------------
> > One thing I am confused about this one is that I read that if I am using
> > anonymous authentication I have to give the IUSR_ComputerName account
read
> > permission to the SQL replication snapshot folder which isn't a problem
> > when
> > IIS and SQL are on the same server but how do I give a local user on one
> > computer permission to a resource on a different server?
> >
> > I would ideally like to get this working on the first server but I
> > installed
> > it on the second one to see if it would help me figure it out.
> >
> > BTW, I am running this on the Pocket PC 2002 Emulator instead of the
2003
> > one.
> > "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > message
> > news:OgSX6ydSFHA.508@xxxxxxxxxxxxxxxxxxxxxxx
> >> you have an issue with permissions on the IIS virtual directory.
> >> for now, enable anonymous access the the virtual directory and
> >> check the box for scripts and executables in the IIS permissions
> >> dialog.
> >>
> >> btw - you did setup the virtual dir and permissions using the wizard
> >> right? if not, run that wizard from the server tools directory.
> >> --
> >> Darren Shaffer
> >> .NET Compact Framework MVP
> >> Principal Architect
> >> Connected Innovation
> >> www.connectedinnovation.com
> >>
> >>
> >> "Bruce Groen" <bruceg@xxxxxxxxxxxxxxxx> wrote in message
> >> news:%23U1kfvaSFHA.3296@xxxxxxxxxxxxxxxxxxxxxxx
> >> >I tried what you suggested with going to the url from the pocket pc
and
> > I
> >> > got a Error Code 10060: Connection Timeout. I didn't mention before
> > that
> >> > I
> >> > am trying to run this from the Emulator not from an actual pocket PC.
> >> > I
> >> > pointed a different computer to this same url and it started to
> >> > download
> >> > the
> >> > dll file to my local machine.
> >> > I just tried it again from the emulator IE but using the IP address
> >> > instead
> >> > of the computer name and now I get a Enter User Name and Password
> >> > screen
> >> > for
> >> > the network resource. After I try my network password several times,
> >> > it
> >> > give me an unauthorized page. Thanks for any help you can give.
> >> >
> >> >
> >> > Previous Message from other group:
> >> > Bruce,
> >> >
> >> > Two things:
> >> >
> >> > 1. start by verifying that you can get to the virtual directory. On
> > your
> >> > device,
> >> > go to Pocket IE and enter url:
> >> > http://{your_machine_name_or_ip_address}/{virt_dir_name}/sscesa20.dll
> >> >
> >> > if you don't get a response from that, you have some network
> >> > connectivity -or- virtual directory
> >> > config issue
> >> >
> >> > 2. there is a newsgroup for sql ce which I take care of.
> >> > microsoft.public.sqlserver.ce - see you there.
> >> > --
> >> > Darren Shaffer
> >> > .NET Compact Framework MVP
> >> > Principal Architect
> >> > Connected Innovation
> >> > www.connectedinnovation.com
> >> >
> >> > "Bruce Groen" <bruceg@xxxxxxxxxxxxxxxx> wrote in message
> >> > news:OdRmjD0RFHA.2136@xxxxxxxxxxxxxxxxxxxxxxx
> >> >>I am new to pocket pc programming but I am trying to write a database
> > app
> >> >> using SQLCE and synching with a SQL 2000 database. I have
downloaded
> >> >> a
> >> >> couple of sample applications but I can't get any of them to work.
> >> >>
> >> >> I have downloaded SQLCE 2.0 and installed it and created a virtual
> >> >> directory
> >> >> for it. When I try to synch with this sample app I get:
> >> >> Error:80004005
> >> >> The gateway has timed out. [,,,,,]
> >> >> Native Error: 28026
> >> >> Microsoft SQL Server 2000
> >> >> Windows CE Edition
> >> >>
> >> >> This happens on the initial synch so I have never successfully been
> > able
> >> >> to
> >> >> synch with the database. I have also tried to enable logging based
on
> > a
> >> >> knowledge base article I read but that doesn't seem to work either.
> > Any
> >> >> help would be appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>


.