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

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article has been archived. It is offered "as is" and will no longer be updated.
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 Edition 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 Edition. 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. This problem was fixed in SQL Server 2005 Compact Edition.
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 Edition, 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:SQL Server Mobile Server Agent is the component that manages communication between SQL Server and SQL Server Mobile Edition. For more information about the SQL Server Mobile Server Agent, visit the following Microsoft Developer Network (MSDN) Web site: For more information about the Configure Web Synchronization Wizard, visit the following MSDN Web site: For more information about how to use Internet Explorer to verify the SQL Server Mobile Server Agent configuration, visit the following MSDN Web site:
Properties

Article ID: 912430 - Last Review: 12/09/2015 04:10:33 - Revision: 2.3

Microsoft SQL Server 2005 Compact Edition

  • kbnosurvey kbarchive kbexpertiseadvanced kbtshoot kbsql2005tool kbprb KB912430
Feedback