Connecting to IIS from SQL Server CE

[Jen]

Hello,
I am having a problem in my pocket pc application where I have an
error: "A request to send data to the computer running IIS has
failed." I have SQL Server CE installed and IIS and SQL Server 2000 on
the same machine. I have an account IUSR_INTERN and also my own user
ID that has rights to everything. I have tried both Anomomous
permissions as well as Integrated Windows Authentication. Both have
not worked. It has that error: 80072EFD
HResult. But that doesn't really explain much. Is there any way I can
get more details about that error? I am just trying to set up the
sample application in Visual Studio .NET NorthwindCE. Does anyone have
any ideas what the problem might be?
Thanks,
Jennifer

 

[Darren Shaffer]

Jen,

You'll get that message if the network path from your device to the IIS
server cannot
be found. First, check that you can hit sscesa20.dll from Pocket IE on
device. If this
works, then the issue is likely the credentials you have setup on IIS and/or
SQL Server.
If you are using Integrated Security with the default machine account
(IUSR_INTERN),
make sure you explicitly grant this account read/write permissions on the
appropriate
database within SQL Server.

Darren Shaffer
Principal Architect
Connected Innovation

 

[Jen]

Hello,
I am able to view the file on my PC
http://127.0.0.1/SharedFolder/thedllfile

but not in IE on my pocket PC.
Am I supposed to be able to view that address (localhost)
on my pocket PC? If I am, how can I fix it?
Thanks!

 

[Alex Feinman [MVP]]

127.0.0.1 is a localhost (loopback) address. If used on PDA it points to
PDA. Use the actual IP address of your computer

 

[Jen]

Hi, I finally got that error to go away, now I am getting an error
"Initializing SQL Server Reconciler has failed". Do you have any idea
what the problem might be? Also, where is the "Normal snapshot folder"
located at?
Thanks,
Jennifer

 

[Jen]

I am having this error: merge process could not connect to the
distributor. Also, if I look in the Merge Agents folder I don't see
anything. I have a snapshot agent and it says the snapshots were
completed successfully.
Thanks,
Jennifer

 

[Alex Feinman [MVP]]

See if this helps:

----------------------------------------------------------
Re: Merge Replication Error 08 Oct 2003 15:17
"Kevin Boske - [MS]"

How are you connecting to your SQL Server? Via NT_AUTHENTICATION or
DB_AUTHENTICAION? If it is NT_Authentication, verify that your IIS
user
has permission to connect to the Distributor. If it is
DB_Authentication,
make sure that you are passing the proper DistributorLogin and
DistributorPassword values.

Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp



http://msdn.microsoft.com/SQL/SQLCE...y/en-us/dnsqlce/html/sqlce_troubleconnect.asp