Wednesday, January 5, 2011

No connection to SQL Server Compact from Microsoft SQL Server 2011

There appears to be no way to connect to SQL Server Compact using the SSMS installed with SQL Server 2011 (Denali). There is however a menu item that indicates that one should be able to connect but it stops there. This menu item when chosen does not provide a SQL Compact Editor icon which used to be available in earlier versions.












The !sorry Mozilla you could not show this (Firefox Version 3.6.13.)!  button (the last item in the drop-down list) in the 'Connect to Server' window used to have an opening to the file system to find the SQL Server Compact files if there were any. But this not possible as you can only browse for servers and not files in the new SSMS.