Error when setting up MS SQL Server Compact

Asked By paulc 0 points N/A Posted on - 11/17/2011

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..

 

• Status: Open
• Question Views: 1015
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Scott Douglas

Go To Solution

Answered By Zorian Crust 80 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!

 

-Zorian

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 11/18/2011
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By Scott Douglas 5 points N/A #111879

Error when setting up MS SQL Server Compact

 

Hi,

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.

About Scott Douglas

Questions
3

Answers
102

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 12/19/2012
• Question Category: MS SQL Server