Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 912430 - Last Review: November 20, 2007 - Revision: 2.3
You cannot replicate data from SQL Server 2005 to SQL Server Mobile Edition by using the 64-bit version of IIS
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
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
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.
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 "More Information" 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
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.
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:
APPLIES TO
- Microsoft SQL Server 2005 Compact Edition
| kbexpertiseadvanced kbtshoot kbsql2005tool kbprb KB912430 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate