PPC Application, 2003 Server settings? (SQL CE, IIS)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: phonix (phonix_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 14:05:02 -0800

Upgrade from Windows 2000 IIS Server to 2003 IIS Server caused issue in
mobile application using SQL Server CE 1.1.
 
Are there system or domain users that need Administrative rights on 2003?
Merge replication traditionally requires an initial push down when occurring
from one server to another, virtual included; but with pull-down merge
replication nothing is created on the end-user device until the request is
received by the database server.
 
The order is as follows...
Publication is created on the database server.
SQL Server CE 2.0 and .NET Framework 1.1 sp1 is loaded on the IIS Server.
The request for the publication is passed through the IIS server to the
database server using a DLL file, SSCESA20.dll.
The temporary files are created on the IIS server during the process of this
request and are sent down to the Pocket PC device requesting them.
 
I hit the server, http://www.siteurl.com/mobileapp/sscesa20.dll
and after logging in, get this message "SQL Server CE Server Agent"
So I know the dll is set up correctly. However, no temporary files are being
created upon the pull-down request.
 
On the 2000 server I did not need to specify the domain to login, on 2003 I
do.
Is there a link to instructions on how to get a mobile application set up
and talking to a device with two 2003 Servers using SQL Server CE 2.0 to
relay the data?
Are there any ports besides :80 that need to be enabled on a firewall for
this to work?

Thank You & Best Regards, Joe

Relevant Pages

  • Error creating PowerPoint.Application object
    ... I'm currently looking at this VB.NET code running on my IIS server which ... server, run a macro and close the PPT. ... granting access rights to the resource to the ASP.NET request identity. ... If the application is impersonating via, ...
    (microsoft.public.dotnet.framework.interop)
  • Re: IIS Problem ...
    ... Request will be rejected. ... processed by a typical IIS server. ... content to an IIS server via WebDAV. ... Maps to webhits.dll, part of Index Server ...
    (microsoft.public.dotnet.general)
  • Re: HttpWeb Request from Class Library fails to 500
    ... I agree with Joerg, since the IIS server has received the request, it is ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SQL Server 2K5 - SSIS
    ... Failed to retrieve data for this request. ... connectionInfo, IDbConnection liveConnection, Boolean validateConnection) ... server, String& serverVersion) ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: Cant run IIS and SQL Server on Separate Machines with Trusted Connection
    ... For Delegation to work, you need to make sure that you have configured ... IIS Server must be trusted for delegation(Open AD Users and Computers mmc ... You need to register an SPN for SQL Server, ...
    (microsoft.public.sqlserver.security)