Friday, February 17, 2012

Connecting via Management Studio

hi,

I've installed Microsoft SQL Server Compact Edition 3.1 .I want to connect to via management studio , but I dont khonw how!

SDK says :

1. In SQL Server Management Studio, open Object Explorer.

2. In Object Explorer, click Connect, and then choose SQL Server Compact Edition.

but there is no "Server Compact Edition" !

please help, Thanks

In my installation, it is still called SQL Server Mobile Edition, not Compact Edition, in the Object Explorer > Connect menu.

HTH,
Jon
|||

It is working but I doubt that it is the CE 3.1 !

Thanks.

|||

Your doubt is justified

There's "Compact Edition" all over the management studio

In VS2005 prof i first installed the SP1 then: (in this order)

SSCE31VSTools-enu-exe

SQLServerCE31-EN.msi

SSCE31BOL (Books online)

SSCE31SDK-ENU.msi

After that the newest version of management studio express (SQLServer2005_SSMSEE.msi)

This is how I did connect.

(Though not everything works: see my message somewhere below!

Anne-Jan Tuinstra

|||I Download and install "SQLServer2005_SSMSEE.msi" but the server type in this version is "Database Engine" and I can't change it!(It is disabled)|||Any idea ? Please help!

No comments:

Post a Comment