Welcome to Julian Kuiters Friday, October 19 2018 @ 08:53 AM AEDT

How to Connect to a SQL Server Compact Edition Database with Management Studio

SQL Server 2005 Compact Edition

Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio.

Change the Server Type to SQL Server Compact Edition.

For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a .sdf file.

Enter a password if required.