I am using SSMS 2012 and trying to connect to the SDF created by Orchard. According to this answer, I should be able to select SQL Server Compact Edition as the Server type when connecting my object browser, but that isn't an option. Is there something I need to install? Did I miss part of the install originally (when setting up SSMS)?
SQL Server Compact is no longer supported in SSMS 2012, I have a list of available tools from Microsoft and others here: http://erikej.blogspot.dk/2009/04/sql-compact-3rd-party-tools.html
UPDATE: My SQL Server Compact Toolbox now supports SSMS 16 and 17
Reference: Discontinued Management Tools Features in SQL Server 2012