Monday, March 19, 2012

MSDE & SQL Server 2005 Mobile Server Tools problem

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000?

We have NOT tested SQL CE/Mobile Merge Replication with MSDE. And, we dont know the problems you may face.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I've been using MSDE with SQL CE 2.0 without any problems.

With the release of Windows Mobile 5.0 I had to upgrade my applications using VS 2005 and start using SQL Server 2005 Mobile Edition instead of SQL CE2.0.

With SQL Server 2005 Express Edition things changed a little bit, because this version only works as a Subscriber when using Replication (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp).

The scenario is quite simple. After installing MSDE(SP4) in Windows XP Professional(SP2) and installing Microsoft SQL Server 2000 SP4 Replication Components and Microsoft .NET Framework 2.0 I try to install the SQL Server 2005 Mobile Server Tools, but during the System Configuration Check that error is displayed.

|||Any tips on how it can be achieved? MSDE - SqlCE merge replication I mean.
There is a problem which I'm trying to solve for quite some time:
SQL Server 2000 - SqlCE merge replication works just fine, but in MSDE -SqlCE scenario it seems to be some trouble.
I always get the same error: 29045 - reconciler has failed. Basically it means, that SqlCE server agent cannot start Reconciler under MSDE. What can cause such a disaster? Incompatibility of components used? This isnt connectivity or access rights issue, i'm pretty sure of it.
I've tried to use different versions of MSDE: MSDE SP4 and MSDE SP3a. Searching in different newsgroups for a couple of hours makes me think that older versions of MSDE are more suitable for my task because few posts stated that merge replication works on MSDE SP3a, but this subject isnt covered in detail. Can you provide any help?|||

READ MY POST YESTERDAY

we are all waiting for Microsoft to bring this function

I will pay for it as you probably will as well

I dont understand why we are the only developers putting pressure on this matter

We need help. The other case is that we can begin referring other 3rd party non microsoft providers....

|||

You need to get onto my post and tell them you want it too

|||

If you are looking for SQL Mobile/SQL Ev to SQL Server synchronization you need to have either SQL Server 2000 or SQL Server 2005 Standard Edition and above.

Thanks

Laxmi Narsimha Rao ORUGNATI, MSFT, SQL Everywhere (SQL Ev), Microsoft Corp.

No comments:

Post a Comment