Error when setting up MS SQL Server Compact

Asked By 0 points N/A Posted on -

I got this error message (see below) while setting up Microsoft SQL Server Compact 3.5 on our SQL Server.  I tried reinstalling it but the same error happened.  I checked the internet for some resolutions but I couldn’t find anyone who had the same situation as I was. 

Anyway, can someone please help me resolve the issue?  Need it very badly.  Thanks in advance.

SQL Server Setup failure.

SQL  Server Setup has  encountered the following error:

MsGetProducetInfo failed to retrieve ProductVersion for package with Product Code=’{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}’. Error code:1608..


Best Answer by Scott Douglas
Answered By 0 points N/A #111878

Error when setting up MS SQL Server Compact


Hello Paulc,

I recommend you to install SQL Server 2010. It is an express edition which includes SP2. The installation should also include WPI or Microsoft Web platform or files that are directly downloaded through microsoft. When using Microsoft Web platform Installer, it may require to install other component which are listed below:

  • Native Client
  • Shared management Objects
  • Management Studio
  • SQL Server
  • CLR Types

You don't have to worry about the components because they can help you solve your problem. It may take some time to download and install but it will be worth it, I hope it might help.Good luck!



Best Answer
Best Answer
Answered By 0 points N/A #111879

Error when setting up MS SQL Server Compact




I will tell you how to solve this problem. Please follow the Instruction that I have given below.

Note: Read very carefully before you do anything.


1.       Then Click Start > in the search box, type regedit and press Enter.

2.       Now Registry Editor appears. Locate the UpgradeCodes folder. You can find this folder by taking this path. HKEY_CLASSES_ROOTInstallerUpgradeCodes

3.       Right click the UpgradeCodes folder and select Export.

4.       Save the registry folder in your hard drive.

5.       Then you have to rename the UpgradeCodes to something else. Let’s rename it to UpgradeCodesOLD. So you can easily remember it.

6.       Now install Microsoft SQL Server. You should install this manually. This is very important. If you don’t know how to install this manually you can follow instructions from given in the site.


7.       Now again go to the registry editor and import the registry folder which you have exported before.

Now you can check the problem.

Hope this will solve your problem.

Login/Register to Answer

Related Questions