How to connect to SQL Server CE file using SSMS

Question

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)?

Crumble

Duplicate of stackoverflow.com/questions/12427459 – Riesling

Answer 1

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

Kurtkurth

G'ack. Yeah, I opened SSMS 2008 R2, and there it was. Booo (to the missing feature in 2012). – Transducer