problem when running "configuration web synchronization"

Hi, there;
We have device using sqlce2.0 and replicate data with sql2000.

Now we have new WM5 device which uses SqlCe3.0. So I need to install connectivity tools
using "SqlCe30setupen.msi".

I got error when I run "Configure Web Synchronization Wizard": The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib).

When I run this wizard, I logged in the server as "Administrator" and point to the existing snapshot folder which is used by sqlce2.0.

Can anybody advise what cause the problem? Can I install it in the same virtual directory as the current one where the sqlce2.0 sits in?

Big thanks here.

You should install in a new virtual folder.|||Thanks, Erik;
Yes, I tried to install it new virtual folder. But I have this error.

Another question is that which user should I use to install it?

Cheers|||

Hey Qiuwei,

You should install Server Tools MSI in admin account. Also note that ConnWiz that is installed by this MSI, should be run under network user who is into administrators group of the box. Please use a different Virtual Directory for 2.0 and 3.0.

Thanks,

Laxmi

|||Yes. Thank you.
I did that. And I have to add user "IUSR_machineName"(with some permission) to that folder to make it work.

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.

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.