Sql server compact 3.5 sp2 failed to install error 1935

Troubleshooting SQL Server Compact 3.5 SP2 Installation Errors: Error 1935

====================================================================

When attempting to install or update Microsoft Sync Framework with SQL Server Compact Edition (CE) 3.5 Service Pack 1 (SP2), users may encounter a puzzling error message stating that the installation of SQL Server Compact 3.5 SP2 failed due to error code 1935.

This article delves into the causes and solutions for this common issue, helping you resolve the problem quickly so you can focus on developing your Windows-based applications.

Causes of Error Code 1935

------------------------

Error code 1935 typically indicates that a dependent assembly required by SQL Server Compact CE cannot be found or has been corrupted. This could be due to various reasons such as:

1. Missing dependencies: The .NET Framework and/or other prerequisite components necessary for SQL Server CE may not have been installed properly.

2. Corrupted installation files: During download, the setup package might have become damaged or partially downloaded, leading to missing or corrupt files required by SQL CE.

3. Conflict with existing versions: If multiple instances of SQL Server CE are already installed on your system, version conflicts can arise and cause this error.

Troubleshooting Steps

-----------------

To resolve Error 1935 when trying to install SQL Server Compact CE 3.5 SP2:

### Step 1 - Verify .NET Framework Installation

Firstly, ensure that the correct versions of the Microsoft .NET Framework are installed on your system:

* For x86 (32-bit) architectures: Download and install '.NET Framework 3.5 Service Pack 1'(https://www.microsoft.com/download/10358/en/netfx35sp1.exe)

* For x64 (64-bit): Use the 'x86 version of .NET Framework 3.5 SP1 instead'(https://www.microsoft.com/download/10358/en/dotnetfx35sp1en_x86exe)

### Step SQL Server Compact CE Prerequisites

Before proceeding with installing SQL CE, make sure you have downloaded and installed all necessary prerequisites:

* Download the 'SQL Server Compact 3.5 SP2 Setup.exe'(https://www.microsoft.com/download/416549)

* Run the setup as an administrator to ensure proper installation.

### Step 3 - Repair or Reinstall Microsoft Sync Framework

If none of the above steps resolve the issue, try repairing or completely uninstalling and reinstalling Microsoft Sync Framework:

1. Go to Control Panel > Programs and Features (or Add/Remove Programs in Vista).

2. Locate 'Microsoft Sync Services 2.0 Client' under Installed Updates, right-click it, then select Uninstall.

3. Once the uninstallation process is complete, restart your system if prompted.

4. After restarting, download and install 'SQL Server Compact 3.5 SP2'(https://www.microsoft.com/download/416549) again from scratch.

### Step 4 - Run Setup as Administrator

During installation, ensure that you run the setup executable (usually `SQLEXPRESS.exe`) with elevated privileges:

1. Right-click on the downloaded installer and select Run as administrator.

2. Follow the wizard prompts to complete the SQL Server Compact CE 3.5 SP2 installation.

Troubleshooting Additional Steps

-----------------------------

If none of these steps resolve your issue, you can try additional troubleshooting measures such as:

* Check for any existing installations or leftover folders related to Microsoft Sync Framework and/or SQL Server CE in `C:\Program Files` (or `C:\Program Files(x86)` on 64-bit systems), then manually delete them.

* Use the 'Microsoft .NET Framework Cleanup Tool'(https://support.microsoft.com/en-us/KB318754) to completely remove all versions of the .NET Framework and its associated components, followed by a system restart before attempting installation again.

-------

In conclusion, error code 1935 during SQL Server Compact CE 3.5 SP2 installation can be attributed to various reasons such as missing or corrupt dependencies, version conflicts, or even simple setup issues. By following the troubleshooting steps outlined above and ensuring that all necessary prerequisites are met before attempting installation should resolve this common problem.

If you continue encountering errors despite trying these measures, consider seeking further assistance from Microsoft Support resources for more detailed guidance specific to your situation.

Sql server compact 3.5 sp2 failed to install error 1935