Why is SQL Server Compact Edition missing from the list of server types in SQL Server Management Studio 2008? -


I have 'SQL Server Compact 3.5 Service Pack 1' and 'SQL Server Management Studio 2008' (SSMS) installed on both PC. In the past, I was doing 'SSL Server Compact Edition' in SSMS in the 'Connect to Server' dialogue from the list of 'Server Type' list. This entry is currently missing and I am not able to restore it.

Apparently there are two ways it can be.

  1. 'SQL Server Compact 3.5 SP1 query tools' has been uninstalled.
  2. Select 'Repair' option 'SQL Server 2008'. For details check under the section titled 'SQL Server Management Studio 2008 Integration'.

The solution for both reasons is to restore the 'SQL Server Compact 3.5 SP1 query tools'. The installation package has been named 'SSCESqlWbTools' and can be found on either 'SQL Server 2008' or the installation media.


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

jquery - SimpleModal Confirm fails to submit form -

php - Multiple Select with Explode: only returns the word "Array" -