Re: SQL CE Synching Problems

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


.

Relevant Pages

  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Location for shared Access database
    ... Can anyone tell me where I should put a simple Access database file in order to be accessible for every computer in the network? ... I don't think that the "Programs" folder is the right place. ... For a network-shared database, use SQL Server instead: ... This will work on Vista as well, although you'll need to adjust the local folder permissions since users don't have write permissions on c:\ by default. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: error: "Failed to generate a user instance of SQL Server due to a failure in starting the proces
    ... time the user creates a User Instance connection, ... Files\Microsoft SQL Server] directory. ... folder to the Microsoft supposed "default" folder, ... I've checked the permissions and found that the ASPNET user not listed on ...
    (microsoft.public.sqlserver.connect)
  • Re: Permissions Issue
    ... If the problem is permissions, then enabling auditing should let you see the ... If the SQL client is running this application across the network using Named ... Pipes or Multi-Protocol to connect to the SQL server with SQL authentication ...
    (microsoft.public.win2000.security)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)