Microsoft KB Archive/912430

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

Article ID: 912430

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Compact 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,  is the name of the computer that is running IIS. Additionally,  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:  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 &quot;More Information&quot; section. 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. 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 &quot;Applies to&quot; 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&amp;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

Keywords: kbexpertiseadvanced kbtshoot kbsql2005tool kbprb KB912430

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.