SQL CE 2.0 can not be installed

[Guest]

Hi Friends!
I am running Visual Studio.Net 2003 on Windows Xp. Sql Server 2000 SP3 is
also installed. I am trying to install SQL Server CE Server Tools from a file
sqlce20sql2ksp2 placed in "C:\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE" folder.

But it shows an error "ERROR : SQL Server CE server tools is compatible
only with SQL server 2000 service pack 1 and higher. When you install SQL
Server CE server tools on a computer running IIS and SQL Server 2000, Ensure
the installer for SQL Server CE server tools corresponds to the version of
SQL server 2000."

I have extracted the zip file to a Folder and then trying to run the MSI but
the error is same.

If any of you have solved this problem, please inform me.
Thanks,
Amit

 

[Syed N. Yousuf [MS]]

The error says ".. Ensure the installer for SQL Server CE server tools
corresponds to the version of
SQL server 2000."

Since you have Sql Server 2000 SP3, you will need the following package:

Upgrading IIS Server After Applying SQL Server 2000 Service Pack 3 or 3a
http://www.microsoft.com/sql/ce/downloads/sp3.asp

You can access SQL Server CE Knowledge Base articles at:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO
( select ' SQL Server CE ' as the product )

Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.