I have both 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on my PC. In the past, I was able to select 'SQL Server Compact Edition' from the list of 'Server Types' in the 'Connect to Server' dialog within SSMS. This entry is now missing and I have not been able to restore it.
Sql – Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Studio 2008
sql-server-2008sql-server-cessms
Related Topic
- How to edit one specific row in Microsoft SQL Server Management Studio 2008
- Sql-server – SQL Server 2008 to SQL Server Compact Edition
- SQL Server Management Studio missing
- Where is SQL Server Management Studio 2012
- How to find server name of SQL Server Management Studio
- Sql – Rename column SQL Server 2008
Best Answer
There are apparently two ways that this can happen.
The solution to both causes is to reinstall 'SQL Server Compact 3.5 SP1 Query Tools'. The installation package is named 'SSCESqlWbTools' and can be found on either the 'SQL Server 2008' installation media or on the Microsoft Download Center.