Menu
I need to set up and maintain my MS Sql CE 4.0 database. I have created the 4.0 DB (with the .sdf extension) using visual studio 2010 but when I try and connect with management studio 2008 I get this error:
'Incompatible Database Version'
This is unreal is microsoft really telling me I cant use 4.0 with a management studio?
I don't really much fancy scripting everything...I need to use the studio for dev purposes.
Any ideas?
640
Check to see if allow remote connections for this server is enabled. In SSMS, right click on the instance name and select Properties. Go to the Connections tab and make sure Allow remote connections to this server is checked. If you need to make a change, you must restart the SQL Server instance to apply the change.
Close the SSMS application (if it is running). On the computer, go to Control Panel > All Control Panel Items > Programs and Features. From the list of programs, right click SQL Server Management Studio and click Uninstall. Click Repair to begin the SSMS install repair.
SSMS 2008 does not support version 4.0, and never will. You can use VS 2010 SP1 with SQL Server Compact 4.0 tools (potentially in combination with htp://sqlcetoolbox.codeplex.com) or on of the tools listed here: http://erikej.blogspot.com/2009/04/sql-compact-3rd-party-tools.html
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
