You need to install the SQL Server replication components as indicated. See this page for detailed instructions:
http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx
|||Thanks EricEJ,
I have already tried this. If you take a closer look at the link that you sent me you will see that Windows Vista OS is not included. Any other ideas?
|||You can install SQL 2005 Developer edition replication tools on Vista. (The page is at bit outdated, correct, but SQL CE 3.1 IS supported on Vista)|||Yes but SQLCe 3.1 is for SQL Server Compact Edition and not SQL Mobile 2005. Am I right or wrong?|||The server tools (which require the replication components to be installed) will work both with SQL Mobile (3.0) and Compact Edition (3.1)|||I have exactly the same problem on an XP machine the tools install as you would expect however on the Vista Machine it will not. Any assistance would be greatly appreciated.|||Please see this KB article for issues regarding installation on Vista: http://support.microsoft.com/Default.aspx?kbid=920700
Look at the heading called Known issues for SQL Server Compact Edition 3.1 on Windows Vista.
I quote from same KB article: "The SQL Server Compact Edition Runtime is supported on Windows Vista."
|||Eric that was just what i needed to get it running:Issue 2
When you run SQL Server Compact Edition Server Tools (Sqlce30setupen.msi) Setup under Least Privilege to User Accounts (LUA) mode on Windows Vista, you receive the following error message:
SQL Server Replication Components not found
This issue occurs even if the SQL Server replication components are present. When you run the Sqlce30setupen.msi file, you receive a message that asks you to use elevated privileges. However, even after you click Yes in the message, you still experience this issue.
Open a Command Prompt window that has elevated privileges, and then run the Sqlce30setupen.msi file.
