Re: SQL CE Synching Problems



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


.



Relevant Pages

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • Re: Permission Problems SBS2003 R1
    ... website on the SBS server? ... Default permissions and user rights for IIS 6.0 ... Step 3: Please check the permissions in IIS manager: ... Step 4: Re-running CEICW on SBS server: ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003/member Web Server and ISUR access
    ... NTFS permissions for the directories and files ... the IIS content directories have the following permissions. ... Server Extensions, ASPNET, SQL Server and other software is installed. ... The IUSR_MachineName account has the following permissions. ...
    (microsoft.public.windows.server.sbs)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)