I recently upgraded SQL 2005 to SQL 2008 R2 in order for a business program to operate properly.  However, since the upgrade, I am now unable to operate Windows Photo Gallery.  The error message indicates that Photo Gallery can't start because Microsoft SQL Server 2005 Compact Edition is missing.  It sends me to a link to install it, but if I install it, I fear that it will overwrite my version of SQL 2008 and I will lose the functionality of my business programs that require 2008.  How do I get Photo Gallery to work with SQL 2008?

Thanks for your help.