You cannot replicate data from SQL Server 2005 to SQL Server Mobile by using the 64-bit version of IIS (912430)


The information in this article applies to:

  • Microsoft SQL Server 2005 Mobile Edition

SYMPTOMS

When you use the 64-bit version of Microsoft Internet Information Services (IIS) to replicate data from Microsoft SQL Server 2005 to SQL Server 2005 Mobile Edition, the replication fails. When you enter http://computername/sqlce/sqlcesa30.dll in Microsoft Internet Explorer to verify the status of the SQL Server Mobile Server Agent (Sqlcesa30.dll), you receive the following error message:
The page cannot be displayed
Note In this error message, computername is the name of the computer that is running IIS. Additionally, sqlce is the virtual directory that you configured in IIS.

You also receive the following error message at the bottom of the page:
HTTP 500 - Internal server error

CAUSE

This problem occurs because replication from SQL Server 2005 to SQL Server Mobile by using the 64-bit version of IIS is not supported.

WORKAROUND

To work around this problem, you can use a computer that is running the 32-bit version of IIS to replicate data from SQL Server 2005 to SQL Server Mobile. To do this, follow these steps:
  1. Install SQL Server Mobile Server Tools on the computer that is running the 32-bit version of IIS.

    Note For more information about SQL Server Mobile Server Tools, see the "More Information" section.
  2. Click Start, point to All Programs, point to Microsoft SQL Server 2005 Mobile Edition, and then click Configure Web Synchronization Wizard.

    The Configure Web Synchronization Wizard guides you through the remaining steps.
  3. To make sure that you have configured SQL Server Mobile Server Agent successfully, enter http://computername/sqlce/sqlcesa30.dll in Internet Explorer.

    You receive the following message: SQL Server Mobile Server Agent 3.0

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

SQL Server Mobile Server Tools updates the server that is running IIS to support connectivity solutions from a SQL Server Mobile database on a mobile device to a database server that is running SQL Server 2005. When you switch to a different computer that is running IIS to replicated data from SQL Server 2005 to SQL Server Mobile, you have to reinstall SQL Server Mobile Server Tools on that computer. To download SQL Server Mobile Server Tools, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6ed0fb7e-7c05-4f59-879a-8fb619e36612&DisplayLang=en

SQL Server Mobile Server Agent is the component that manages communication between SQL Server and SQL Server Mobile. For more information about the SQL Server Mobile Server Agent, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/library/ms171927.aspx

For more information about the Configure Web Synchronization Wizard, visit the following MSDN Web site:

http://msdn2.microsoft.com/ms172465.aspx

For more information about how to use Internet Explorer to verify the SQL Server Mobile Server Agent configuration, visit the following MSDN Web site:

http://msdn2.microsoft.com/en-us/library/ms172073.aspx

Modification Type:MajorLast Reviewed:1/26/2006
Keywords:kbExpertiseAdvanced kbtshoot kbsql2005tool kbprb KB912430 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.