Connecting to IIS from SQL Server CE

  • Thread starter Thread starter Jen
  • Start date Start date
J

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
 
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
 
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
 
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
 
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
 
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
 
Back
Top