Accessing SQL Server Compact from SSMS 2008 R2

Asked Feb 09 '18 at 13:22

Active Feb 09 '18 at 14:25

Viewed 106 times

I am using SQL Server 2008 R2 with SSMS, and I want to connect to SQL Server Compact (sdf files) but the option is disabled (greyed out).

This is how it looks like:

enter image description here

I also installed SQL Server Compact 3.5 SP 2 and their tools, see the first 2 items, but it stays greyed out:

enter image description here

Who knows a solution?

edited Feb 09 '18 at 14:25

Peter B

asked Feb 09 '18 at 13:22

Not everybody here likes SHOUTING.... – Peter B Feb 09 '18 at 13:26
I am sorry. I edited te question. I didn’t want to be a inpolite – Cesar Ivan Ardila Vega Feb 09 '18 at 13:42
Thanks, appreciated :-) – Peter B Feb 09 '18 at 14:20
Thanks, could you help me to resolve the issue? please. I will really appreciated! – Cesar Ivan Ardila Vega Feb 09 '18 at 14:27
No experience with SQL Compact. You could try **[SSMS v2017](https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms)**, it's free, and it offers lots of new features & improvements. Worth a try IMHO – Peter B Feb 09 '18 at 15:31

0 Answers0