Problem using SQL Server Mobile 2005 with WM5 and Windows Vista

I have a problem using Remote Data Access (RDA) to connect SQL Server Mobile 3.0 and SQL Server Express 2005 in windows Vista. The problem is that I can't install SQL Server Windows Moble 3.0 because i get a message that no replication componets have been istalled. I thought that installing SQL Server Mobile would do that. Any ideas?

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.

Workaround for issue 2

Open a Command Prompt window that has elevated privileges, and then run the Sqlce30setupen.msi file.

|||Happy to be able to help.