Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 31, 2013 05:46 AM by Angie xu - MSFT
Jan 25, 2013 04:33 AM|LINK
I'm wanting to install WebMatrix but already have a full version of SQL Server 2008 R2 installed. I could not find how to unselect Sql Server Compact from the installable components list. I've looked at "Items to be installed" and "Options". Niether
seem to be the right place. Can someone provide the process to do this?
Jan 25, 2013 04:40 AM|LINK
No issues you can still use sql server 2008 R2 , sql server ce and express and localdb too.
Jan 25, 2013 05:32 AM|LINK
WebMatrix is a package that includes SQL Compact, IIS Express, Razor Web Pages and the IDE. SQL Compact is not an optional component. You could try uninstalling it after the rest has installed, but I don't know what effect that would have on the rest of
Jan 31, 2013 05:46 AM|LINK
There are two SQL Server Compact related components that gets installed by SQL Server 2008:
•Microsoft SQL Server Compact runtime (SSCERuntime.msi)
•Microsoft SQL Server Compact Query tools (SSCESqlWbTools.msi)
You can uninstall both these components using either of the following methods.
•Use Control Panel’s Add or Remove Programs applet or Programs and Features (in Windows Vista and Windows 7) to remove these programs.
•Since SQL Server Compact’ MSIs are based on Windows Installer technology you can also use the Msiexec from command line to uninstall these components.
For example, the following command line will uninstall SQL Compact runtime .msi :
msiexec /x ssceruntime_enu.msi
You can run msiexec /? on a command line to see the complete list of options.
After you uninstall these SQL Server Compact components, you will no longer be able to interact with SQL Server Compact databases from SQL Server Management Studio.
hope it helps you,