Welcome to Julian Kuiters Friday, July 20 2018 @ 04:25 PM AEST

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

  • Contributed by:
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.