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

Article translations Article translations
Article ID: 912430 - View products that this article applies to.
Expand all | Collapse all

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:
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 Edition. 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

Properties

Article ID: 912430 - Last Review: November 20, 2007 - Revision: 2.3
APPLIES TO
  • Microsoft SQL Server 2005 Compact Edition
Keywords: 
kbexpertiseadvanced kbtshoot kbsql2005tool kbprb KB912430

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com