Some are having difficulty running Windows Essentials 2012 Photo Gallery as the following error occurs:
0x8007045a
Microsoft SQL Server 2005 Compact Edition is missing.
Windows Essentials 2012 contains the following programs:
Photo Gallery (Windows Photo Gallery 2012 Build 16.4.3528.331)
Movie Maker (Version 2012 Build 16.4.3528.0331)
Windows Live Writer
Windows Live Mail (Version 2012 Build 16.4.3564.1216)
OneDrive
Support for Microsoft SQL Server 2005 Compact Edition ended April 12, 2016.
(Microsoft link from which the above support table was acquired is no longer available.)
1. Verify that Microsoft SQL Server 2005 Compact Edition is not in your programs.
Go to Control Panel > Programs > Programs and Features
If the software is installed, you will see the blue item (highlighted for viewing ease). There are many SQL Servers, but you want this one.
2. If Microsoft SQL Server 2005 Compact Edition is not installed, it may be downloaded from:
https://www.microsoft.com/en-us/download/details.aspx?id=10070
3. Save this file.
4. Install the software.
Then perform the following step to install SQL Server 2005 Compact Edition which is the software you need.
5. "To install the localized version of SQL Server 2005 Compact Edition Runtime from the localized version of SQL Server 2005 Compact Edition Developer SDK, follow these steps:
- Open the following folder: %programfiles%\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\Desktop
- Install the English version of SQL Server Compact Edition Runtime (SQLServerCE31-EN.msi).
- Install the localized version of SQL Server Compact Edition Runtime (SQLServerCE31-[LN].msi)"
If you have a 32-bit operating system, %programfiles% is C:\Program Files:
C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\Desktop
If you have a 64-bit operating system, %programfiles% is C:\Program Files (x86):
C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\Desktop
Source for inks and information:
https://www.microsoft.com/en-us/download/details.aspx?id=10070