Menu
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)?
634
Connect to a SQL Server instance Start SQL Server Management Studio. The first time you run SSMS, the Connect to Server window opens. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine. For Server type, select Database Engine (usually the default option).
To connect to a registered server If the Registered Servers pane is not visible, select View > Registered Servers. In Registered Servers, right-click a server, point to Connect, and then select Object Explorer.
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
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
